/*
Navicat MySQL Data Transfer

Source Server         : 打
Source Server Version : 50623
Source Host           : localhost:3306
Source Database       : bingo

Target Server Type    : MYSQL
Target Server Version : 50623
File Encoding         : 65001

Date: 2016-08-26 11:34:00
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for app_config
-- ----------------------------
DROP TABLE IF EXISTS `app_config`;
CREATE TABLE `app_config` (
  `Config_Key` varchar(50) DEFAULT NULL,
  `Config_Type` varchar(50) DEFAULT NULL,
  `Config_Value` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of app_config
-- ----------------------------

-- ----------------------------
-- Table structure for area
-- ----------------------------
DROP TABLE IF EXISTS `area`;
CREATE TABLE `area` (
  `Code` int(15) NOT NULL AUTO_INCREMENT,
  `Name` varchar(100) DEFAULT NULL,
  `Fun` varchar(100) DEFAULT NULL,
  `Parent` int(15) DEFAULT NULL,
  PRIMARY KEY (`Code`)
) ENGINE=InnoDB AUTO_INCREMENT=300021 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of area
-- ----------------------------
INSERT INTO `area` VALUES ('100000', '中国', 'Country', null);
INSERT INTO `area` VALUES ('200000', '广东省', 'Province', '100000');
INSERT INTO `area` VALUES ('300000', '广州市', 'City', '200000');
INSERT INTO `area` VALUES ('300001', '汕头市', 'City', '200000');
INSERT INTO `area` VALUES ('300002', '湛江市', 'City', '200000');
INSERT INTO `area` VALUES ('300003', '潮州市', 'City', '200000');
INSERT INTO `area` VALUES ('300004', '茂名市', 'City', '200000');
INSERT INTO `area` VALUES ('300005', '深圳市', 'City', '200000');
INSERT INTO `area` VALUES ('300006', '韶关市', 'City', '200000');
INSERT INTO `area` VALUES ('300007', '梅州市', 'City', '200000');
INSERT INTO `area` VALUES ('300008', '惠州市', 'City', '200000');
INSERT INTO `area` VALUES ('300009', '东莞市', 'City', '200000');
INSERT INTO `area` VALUES ('300010', '江门市', 'City', '200000');
INSERT INTO `area` VALUES ('300011', '佛山市', 'City', '200000');
INSERT INTO `area` VALUES ('300012', '肇庆市', 'City', '200000');
INSERT INTO `area` VALUES ('300013', '珠海市', 'City', '200000');
INSERT INTO `area` VALUES ('300014', '中山市', 'City', '200000');
INSERT INTO `area` VALUES ('300015', '河源市', 'City', '200000');
INSERT INTO `area` VALUES ('300016', '汕尾市', 'City', '200000');
INSERT INTO `area` VALUES ('300017', '阳江市', 'City', '200000');
INSERT INTO `area` VALUES ('300018', '清远市', 'City', '200000');
INSERT INTO `area` VALUES ('300019', '揭阳市', 'City', '200000');
INSERT INTO `area` VALUES ('300020', '云浮市', 'City', '200000');

-- ----------------------------
-- Table structure for association
-- ----------------------------
DROP TABLE IF EXISTS `association`;
CREATE TABLE `association` (
  `Association_NO` int(10) NOT NULL AUTO_INCREMENT,
  `School_NO` int(10) DEFAULT NULL,
  `Nature` varchar(100) DEFAULT NULL,
  `Type` varchar(50) DEFAULT NULL,
  `Association_Grade` varchar(10) DEFAULT NULL,
  `Name` varchar(100) DEFAULT NULL,
  `A_Size_NO` int(15) DEFAULT NULL,
  `Dept_Amount` int(2) DEFAULT NULL,
  `LOGO_Path` varchar(100) DEFAULT NULL,
  `Status` varchar(60) DEFAULT NULL,
  `Remark` varchar(255) DEFAULT NULL,
  `Points` int(10) DEFAULT NULL,
  `Create_Time` datetime DEFAULT NULL,
  `Update_Time` datetime DEFAULT NULL,
  `Task_Status` varchar(60) DEFAULT NULL,
  `User_Password` varchar(100) DEFAULT NULL,
  `City_Code` int(15) DEFAULT NULL,
  `Provice_Code` int(15) DEFAULT NULL,
  `City_Name` varchar(200) DEFAULT NULL,
  `Provice_Name` varchar(200) DEFAULT NULL,
  `Nature_NO` int(15) DEFAULT NULL,
  `Type_NO` int(15) DEFAULT NULL,
  `School_Grade_NO` int(15) DEFAULT NULL,
  `School_Grade_Name` varchar(100) DEFAULT NULL,
  `School_Name` varchar(100) DEFAULT NULL,
  `ASize_Discription` varchar(100) DEFAULT NULL,
  `Type_Detail_NO` int(15) DEFAULT NULL,
  `Type_Detail_Name` varchar(100) DEFAULT NULL,
  `Self_Password` varchar(100) DEFAULT NULL,
  `Create_User_ID` int(15) DEFAULT NULL,
  `Create_User_Name` varchar(100) DEFAULT NULL,
  `Total_Money` double DEFAULT NULL,
  PRIMARY KEY (`Association_NO`),
  KEY `FKAssociatio856502` (`School_NO`),
  CONSTRAINT `FKAssociatio856502` FOREIGN KEY (`School_NO`) REFERENCES `school` (`School_NO`)
) ENGINE=InnoDB AUTO_INCREMENT=400000006 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of association
-- ----------------------------
INSERT INTO `association` VALUES ('400000000', '101', '院级', '社团类', 'Gold', '投资协会', '900000104', '10', '010', 'Active', '好帅', '10', '2016-08-24 00:04:30', '2016-08-17 00:04:34', 'Open', null, '300003', '1', '潮州市', '广东省', null, '900000113', '2', '院级', '中山大学', null, null, null, null, null, null, null);
INSERT INTO `association` VALUES ('400000001', '101', '校级', '组织类', 'Agent', '学生会', '900000105', '10', '010', 'Active', '好酷', '10', '2016-08-24 00:04:30', '2016-08-17 00:04:34', 'Open', null, '300004', '1', '茂名市', '广东省', null, '900000112', '1', '校级', '广州大学华软', null, null, null, null, null, null, null);
INSERT INTO `association` VALUES ('400000002', '101', '院级', '社团类', 'Gold', '篮球协会', '900000106', '10', '010', 'Active', '好帅', '10', '2016-08-24 00:04:30', '2016-08-17 00:04:34', 'Open', null, '300010', '1', '江门市', '广东省', null, '900000113', '2', '院级', '华南理工大学', null, null, null, null, null, null, null);
INSERT INTO `association` VALUES ('400000003', '101', '院级', '社团类', 'Ordinary', '电竞协会', '900000107', '10', '010', 'Active', '好帅', '10', '2016-08-24 00:04:30', '2016-08-17 00:04:34', 'Open', null, '300008', '1', '惠州市', '广东省', null, '900000113', '2', '院级', '香港中文大学（深圳）', null, null, null, null, null, null, null);
INSERT INTO `association` VALUES ('400000004', '101', '院级', '社团类', 'Gold', '跆拳道协会', '900000108', '10', '010', 'Active', '好帅', '10', '2016-08-24 00:04:30', '2016-08-17 00:04:34', 'Open', null, '300009', '1', '东莞市', '广东省', null, '900000113', '2', '院级', '北京师范大学珠海分校', null, null, null, null, null, null, null);
INSERT INTO `association` VALUES ('400000005', '101', '校级', '组织类', 'Agent', '会计协会', '900000109', '10', '010', 'Active', '好酷', '10', '2016-08-24 00:04:30', '2016-08-17 00:04:34', 'Open', null, '300004', '1', '茂名市', '广东省', null, '900000112', '1', '校级', '广东海洋大学', null, null, null, null, null, null, null);

-- ----------------------------
-- Table structure for association_student
-- ----------------------------
DROP TABLE IF EXISTS `association_student`;
CREATE TABLE `association_student` (
  `AssociationAssociation_NO` int(10) NOT NULL,
  `StudentStudent_NO` int(10) NOT NULL,
  `Status` varchar(15) DEFAULT NULL,
  PRIMARY KEY (`AssociationAssociation_NO`,`StudentStudent_NO`),
  KEY `FKAssociatio686036` (`AssociationAssociation_NO`),
  KEY `FKAssociatio609651` (`StudentStudent_NO`),
  CONSTRAINT `FKAssociatio609651` FOREIGN KEY (`StudentStudent_NO`) REFERENCES `student` (`Student_NO`),
  CONSTRAINT `FKAssociatio686036` FOREIGN KEY (`AssociationAssociation_NO`) REFERENCES `association` (`Association_NO`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of association_student
-- ----------------------------
INSERT INTO `association_student` VALUES ('400000000', '10000001', 'Active');

-- ----------------------------
-- Table structure for company
-- ----------------------------
DROP TABLE IF EXISTS `company`;
CREATE TABLE `company` (
  `Company_NO` int(10) NOT NULL AUTO_INCREMENT,
  `Company_Name` varchar(60) DEFAULT NULL,
  `Address` varchar(200) DEFAULT NULL,
  `Password` varchar(60) DEFAULT NULL,
  `Web` varchar(100) DEFAULT NULL,
  `Nature` varchar(50) DEFAULT NULL,
  `C_Size` int(15) DEFAULT NULL,
  `Type` varchar(30) DEFAULT NULL,
  `Contact_NO` int(10) NOT NULL,
  `Contact_ID_NO` varchar(20) DEFAULT NULL,
  `License_NO` varchar(120) DEFAULT NULL,
  `License_Name` varchar(120) DEFAULT NULL,
  `License_EndDate` datetime DEFAULT NULL,
  `License_Address` varchar(255) DEFAULT NULL,
  `Status` varchar(60) DEFAULT NULL,
  `Remark` varchar(255) DEFAULT NULL,
  `Points` int(10) DEFAULT NULL,
  `Grade` varchar(50) DEFAULT NULL,
  `Update_Time` datetime DEFAULT NULL,
  `User_Password` varchar(255) DEFAULT NULL,
  `Create_Time` datetime DEFAULT NULL,
  `Nature_NO` int(15) DEFAULT NULL,
  `Type_NO` int(15) DEFAULT NULL,
  `CSize_Display_Name` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`Company_NO`),
  KEY `Company_Name` (`Company_Name`),
  KEY `FKCompany281990` (`Contact_NO`),
  CONSTRAINT `FKCompany281990` FOREIGN KEY (`Contact_NO`) REFERENCES `user_info` (`User_No`)
) ENGINE=InnoDB AUTO_INCREMENT=20000001 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of company
-- ----------------------------
INSERT INTO `company` VALUES ('20000000', 'yui', 'i love yui', '', 'baidu.com', '合资/合作(欧美企业)', '2', '日用消费品', '10000000', '', '3454534534534', '黄烈全', '0001-01-01 00:00:00', '', 'Pending', '', '0', '', '2016-08-20 20:10:37', '', '2016-08-20 20:10:37', '3', '7', '50-149人');

-- ----------------------------
-- Table structure for event_log
-- ----------------------------
DROP TABLE IF EXISTS `event_log`;
CREATE TABLE `event_log` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `Instance_ID` varchar(20) DEFAULT NULL,
  `Event_ID` varchar(45) DEFAULT NULL,
  `Action_Type` varchar(45) DEFAULT NULL,
  `Action_Object` varchar(45) DEFAULT NULL,
  `Action_Time` datetime DEFAULT NULL,
  `Operator` varchar(45) DEFAULT NULL,
  `Remark` varchar(4000) DEFAULT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB AUTO_INCREMENT=64 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of event_log
-- ----------------------------
INSERT INTO `event_log` VALUES ('1', 'SP_A_1', '18825195397', 'SendCAPTCHA', 'UserValidation', '2016-08-20 20:09:07', '18825195397', '{\"ValidID\":0,\"UserID\":null,\"AccountType\":1,\"AccountValue\":\"18825195397\",\"ValidType\":0,\"ValidNo\":\"9551\",\"ValidStatus\":0,\"CreatedTime\":\"2016-08-20T20:08:03.9457909+08:00\",\"UpdatedTime\":\"0001-01-01T00:00:00\"}');
INSERT INTO `event_log` VALUES ('2', 'SP_A_1', 'system', 'Create', 'UserInfo', '2016-08-20 20:09:25', '18825195397', 'UserNO:10000000,UserName:18825195397,NickName:,Password:4dbe3c0dbec4fe8d3009c3b826a6ce2e729d9ec615399c7af237c422beb57b5bcf8a94a65523b94674e3170144abc9ed7aaf8820186684c3befeab8589986387,Role:Company,Sex:Male,CreateTime:');
INSERT INTO `event_log` VALUES ('3', 'SP_A_1', 'system', 'Create', 'Company', '2016-08-20 20:10:37', '10000000', 'CompanyNO:20000000,CompanyName:yui,Address:i love yui,Web:baidu.com,Nature:合资/合作(欧美企业),NatureNO:3,CSize:2,CSizeDisplayName:50-149人,Type:日用消费品,TypeNO:7,ContactNO:10000000,LicenseEndDate:,Status:Pending,Points:0,UpdateTime:,CreateTime:');
INSERT INTO `event_log` VALUES ('4', 'SP_A_1', 'system', 'Create', 'Company', '2016-08-20 20:10:52', '10000000', 'CompanyNO:20000001,CompanyName:yui,Address:i love yui,Web:baidu.com,Nature:合资/合作(欧美企业),NatureNO:3,CSize:2,CSizeDisplayName:50-149人,Type:日用消费品,TypeNO:7,ContactNO:10000000,LicenseEndDate:,Status:Pending,Points:0,UpdateTime:,CreateTime:');
INSERT INTO `event_log` VALUES ('5', 'SP_A_1', 'system', 'Create', 'Company', '2016-08-20 20:11:27', '10000000', 'CompanyNO:20000002,CompanyName:yui,Address:i love yui,Web:baidu.com,Nature:合资/合作(欧美企业),NatureNO:3,CSize:2,CSizeDisplayName:50-149人,Type:日用消费品,TypeNO:7,ContactNO:10000000,LicenseEndDate:,Status:Pending,Points:0,UpdateTime:,CreateTime:');
INSERT INTO `event_log` VALUES ('6', 'SP_A_1', 'system', 'Create', 'Company', '2016-08-20 20:11:33', '10000000', 'CompanyNO:20000003,CompanyName:yui,Address:i love yui,Web:baidu.com,Nature:合资/合作(欧美企业),NatureNO:3,CSize:2,CSizeDisplayName:50-149人,Type:日用消费品,TypeNO:7,ContactNO:10000000,LicenseEndDate:,Status:Pending,Points:0,UpdateTime:,CreateTime:');
INSERT INTO `event_log` VALUES ('7', 'SP_A_1', 'system', 'Update', 'UserInfo', '2016-08-20 20:20:57', '10000000', 'UserNO:10000000,UserName:18825195397,NickName:,Password:,Phone:,Email:,QQ:,WeChart:,Role:Company,UserType:,Sex:Female,CreateTime:[2016-08-20 20:09:25]');
INSERT INTO `event_log` VALUES ('8', 'SP_A_1', 'system', 'Update', 'Company', '2016-08-20 20:20:57', '10000000', 'CompanyNO:20000000,CompanyName:yui,Address:i love yui,Password:,Web:baidu.com,Nature:合资/合作(欧美企业),NatureNO:3,CSize:2,CSizeDisplayName:50-149人,Type:日用消费品,TypeNO:7,ContactNO:10000000,ContactIDNO:,LicenseNO:,LicenseName:,LicenseEndDate:,LicenseAddress:,Status:Pending,Remark:,Points:0,Grade:,UpdateTime:[2016-08-20 20:10:37],CreateTime:[2016-08-20 20:10:37],UserPassword:');
INSERT INTO `event_log` VALUES ('9', 'SP_A_1', 'system', 'Update', 'Company', '2016-08-20 20:21:28', '', 'CompanyNO:20000000,CompanyName:yui,Address:i love yui,Password:,Web:baidu.com,Nature:合资/合作(欧美企业),NatureNO:3,CSize:2,CSizeDisplayName:50-149人,Type:日用消费品,TypeNO:7,ContactNO:10000000,ContactIDNO:,LicenseNO:3454534534534,LicenseName:黄烈全,LicenseEndDate:,LicenseAddress:,Status:Pending,Remark:,Points:0,Grade:,UpdateTime:[2016-08-20 20:10:37],CreateTime:[2016-08-20 20:10:37],UserPassword:');
INSERT INTO `event_log` VALUES ('10', 'SP_A_1', 'system', 'Create', 'Project', '2016-08-20 20:29:07', '10000000', 'ProjectNO:30000000,ProjectName:黄烈全,Region:0,Money:10000,StartTime:[2016-08-17 00:00:00],EndTime:[2016-08-09 00:00:00],Entrants:3,EntrantsName:300-499,ProjectRequire:飞洒登封市大发生发射点,Status:Draft,BookStatus:Pending,Readers:0,LikedCount:0,BelongNO:20000000,BelongType:Company,ContactNO:10000000,UrgentRemark:孙大发大水法,CreateTime:,UpdateTime:,MoneyStatus:NoPayment');
INSERT INTO `event_log` VALUES ('11', 'SP_A_1', 'system', 'Create', 'Project', '2016-08-20 23:53:26', '10000000', 'ProjectNO:30000001,ProjectName:黄烈全,Region:0,Money:10000,StartTime:[2016-08-02 00:00:00],EndTime:[2016-08-02 00:00:00],Entrants:2,EntrantsName:100-299,ProjectRequire:hdfgfdgdfgdfgdg,Status:Draft,BookStatus:Pending,Readers:0,LikedCount:0,BelongNO:20000000,BelongType:Company,ContactNO:10000000,UrgentRemark:3453453,CreateTime:,UpdateTime:,MoneyStatus:NoPayment');
INSERT INTO `event_log` VALUES ('12', 'SP_A_1', 'system', 'Create', 'Project', '2016-08-21 00:17:59', '10000000', 'ProjectNO:30000002,ProjectName:,Region:0,Money:10000,StartTime:[2016-08-17 00:00:00],EndTime:[2016-08-21 00:00:00],Entrants:2,EntrantsName:100-299,ProjectRequire:,Status:Draft,BookStatus:Pending,Readers:0,LikedCount:0,BelongNO:20000000,BelongType:Company,ContactNO:10000000,UrgentRemark:534564,CreateTime:,UpdateTime:,MoneyStatus:NoPayment');
INSERT INTO `event_log` VALUES ('13', 'SP_A_1', 'system', 'Update', 'Project', '2016-08-21 08:05:52', '10000000', 'ProjectNO:30000001,ProjectName:黄烈全,Region:0,Money:10000,MoneyName:,StartTime:[2016-08-02 00:00:00],EndTime:[2016-08-02 00:00:00],Entrants:2,EntrantsName:100-299,ProjectRequire:hdfgfdgdfgdfgdg,Status:Approving,BookStatus:Active,Remark:,Readers:0,LikedCount:0,BelongNO:20000000,BelongType:Company,ContactNO:10000000,UrgentRemark:3453453,CreateTime:[2016-08-20 23:53:25],UpdateTime:[2016-08-20 23:53:25],MoneyStatus:NoPayment');
INSERT INTO `event_log` VALUES ('14', 'SP_A_1', 'system', 'Update', 'Project', '2016-08-21 08:07:53', '10000000', 'ProjectNO:30000001,ProjectName:黄烈全,Region:0,Money:10000,MoneyName:,StartTime:[2016-08-02 00:00:00],EndTime:[2016-08-02 00:00:00],Entrants:4,EntrantsName:100-299,ProjectRequire:hdfgfdgdfgdfgdg,Status:Approving,BookStatus:Active,Remark:,Readers:0,LikedCount:0,BelongNO:20000000,BelongType:Company,ContactNO:10000000,UrgentRemark:3453453,CreateTime:[2016-08-20 23:53:25],UpdateTime:[2016-08-21 08:05:52],MoneyStatus:NoPayment');
INSERT INTO `event_log` VALUES ('15', 'SP_A_1', 'system', 'Update', 'Project', '2016-08-21 08:19:26', '10000000', 'ProjectNO:30000001,ProjectName:黄烈全,Region:0,Money:10000,MoneyName:,StartTime:[2016-08-02 00:00:00],EndTime:[2016-08-02 00:00:00],Entrants:55,EntrantsName:100-299,ProjectRequire:hdfgfdgdfgdfgdg,Status:Approving,BookStatus:Active,Remark:,Readers:0,LikedCount:0,BelongNO:20000000,BelongType:Company,ContactNO:10000000,UrgentRemark:3453453,CreateTime:[2016-08-20 23:53:25],UpdateTime:[2016-08-21 08:07:53],MoneyStatus:NoPayment');
INSERT INTO `event_log` VALUES ('16', 'SP_A_1', 'system', 'Update', 'Project', '2016-08-21 08:24:04', '10000000', 'ProjectNO:30000001,ProjectName:黄烈全,Region:0,Money:10000,MoneyName:,StartTime:[2016-08-02 00:00:00],EndTime:[2016-08-02 00:00:00],Entrants:22,EntrantsName:100-299,ProjectRequire:hdfgfdgdfgdfgdg,Status:Approving,BookStatus:Active,Remark:,Readers:0,LikedCount:0,BelongNO:20000000,BelongType:Company,ContactNO:10000000,UrgentRemark:3453453,CreateTime:[2016-08-20 23:53:25],UpdateTime:[2016-08-21 08:19:25],MoneyStatus:NoPayment');
INSERT INTO `event_log` VALUES ('17', 'SP_A_1', 'system', 'Update', 'Project', '2016-08-21 08:25:45', '10000000', 'ProjectNO:30000001,ProjectName:黄烈全,Region:0,Money:10000,MoneyName:,StartTime:[2016-08-02 00:00:00],EndTime:[2016-08-02 00:00:00],Entrants:45,EntrantsName:100-299,ProjectRequire:hdfgfdgdfgdfgdg,Status:Approving,BookStatus:Active,Remark:,Readers:0,LikedCount:0,BelongNO:20000000,BelongType:Company,ContactNO:10000000,UrgentRemark:3453453,CreateTime:[2016-08-20 23:53:25],UpdateTime:[2016-08-21 08:24:04],MoneyStatus:NoPayment');
INSERT INTO `event_log` VALUES ('18', 'SP_A_1', 'system', 'Update', 'Project', '2016-08-21 08:28:29', '10000000', 'ProjectNO:30000001,ProjectName:黄烈全,Region:0,Money:10000,MoneyName:,StartTime:[2016-08-02 00:00:00],EndTime:[2016-08-02 00:00:00],Entrants:454,EntrantsName:100-299,ProjectRequire:hdfgfdgdfgdfgdg,Status:Approving,BookStatus:Active,Remark:,Readers:0,LikedCount:0,BelongNO:20000000,BelongType:Company,ContactNO:10000000,UrgentRemark:3453453,CreateTime:[2016-08-20 23:53:25],UpdateTime:[2016-08-21 08:25:45],MoneyStatus:NoPayment');
INSERT INTO `event_log` VALUES ('19', 'SP_A_1', 'system', 'Update', 'Project', '2016-08-21 08:50:29', '10000000', 'ProjectNO:30000001,ProjectName:黄烈全,Region:0,Money:10000,MoneyName:,StartTime:[2016-08-02 00:00:00],EndTime:[2016-08-02 00:00:00],Entrants:10,EntrantsName:100-299,ProjectRequire:hdfgfdgdfgdfgdg,Status:Approving,BookStatus:Active,Remark:,Readers:0,LikedCount:0,BelongNO:20000000,BelongType:Company,ContactNO:10000000,UrgentRemark:3453453,CreateTime:[2016-08-20 23:53:25],UpdateTime:[2016-08-21 08:28:29],MoneyStatus:NoPayment');
INSERT INTO `event_log` VALUES ('20', 'SP_A_1', 'system', 'Update', 'Project', '2016-08-21 09:01:11', '10000000', 'ProjectNO:30000001,ProjectName:黄烈全,Region:0,Money:10000,MoneyName:,StartTime:[2016-08-02 00:00:00],EndTime:[2016-08-02 00:00:00],Entrants:20,EntrantsName:100-299,ProjectRequire:hdfgfdgdfgdfgdg,Status:Approving,BookStatus:Active,Remark:,Readers:0,LikedCount:0,BelongNO:20000000,BelongType:Company,ContactNO:10000000,UrgentRemark:3453453,CreateTime:[2016-08-20 23:53:25],UpdateTime:[2016-08-21 08:50:29],MoneyStatus:NoPayment');
INSERT INTO `event_log` VALUES ('21', 'SP_A_1', 'system', 'Update', 'Project', '2016-08-21 09:09:11', '10000000', 'ProjectNO:30000001,ProjectName:黄烈全,Region:0,Money:10000,MoneyName:,StartTime:[2016-08-02 00:00:00],EndTime:[2016-08-02 00:00:00],Entrants:4545,EntrantsName:100-299,ProjectRequire:hdfgfdgdfgdfgdg,Status:Approving,BookStatus:Active,Remark:,Readers:0,LikedCount:0,BelongNO:20000000,BelongType:Company,ContactNO:10000000,UrgentRemark:3453453,CreateTime:[2016-08-20 23:53:25],UpdateTime:[2016-08-21 09:01:11],MoneyStatus:NoPayment');
INSERT INTO `event_log` VALUES ('22', 'SP_A_1', 'system', 'Update', 'Project', '2016-08-21 09:09:53', '10000000', 'ProjectNO:30000001,ProjectName:黄烈全,Region:0,Money:10000,MoneyName:,StartTime:[2016-08-02 00:00:00],EndTime:[2016-08-02 00:00:00],Entrants:4545,EntrantsName:100-299,ProjectRequire:hdfgfdgdfgdfgdg,Status:Approving,BookStatus:Active,Remark:,Readers:0,LikedCount:0,BelongNO:20000000,BelongType:Company,ContactNO:10000000,UrgentRemark:3453453,CreateTime:[2016-08-20 23:53:25],UpdateTime:[2016-08-21 09:09:11],MoneyStatus:NoPayment');
INSERT INTO `event_log` VALUES ('23', 'SP_A_1', 'system', 'Update', 'Project', '2016-08-21 09:10:52', '10000000', 'ProjectNO:30000001,ProjectName:黄烈全,Region:0,Money:10000,MoneyName:,StartTime:[2016-08-02 00:00:00],EndTime:[2016-08-02 00:00:00],Entrants:454,EntrantsName:100-299,ProjectRequire:hdfgfdgdfgdfgdg,Status:Approving,BookStatus:Active,Remark:,Readers:0,LikedCount:0,BelongNO:20000000,BelongType:Company,ContactNO:10000000,UrgentRemark:3453453,CreateTime:[2016-08-20 23:53:25],UpdateTime:[2016-08-21 09:09:53],MoneyStatus:NoPayment');
INSERT INTO `event_log` VALUES ('24', 'SP_A_1', 'system', 'Update', 'Project', '2016-08-21 09:13:27', '10000000', 'ProjectNO:30000001,ProjectName:黄烈全,Region:0,Money:10000,MoneyName:,StartTime:[2016-08-02 00:00:00],EndTime:[2016-08-02 00:00:00],Entrants:55,EntrantsName:100-299,ProjectRequire:hdfgfdgdfgdfgdg,Status:Approving,BookStatus:Active,Remark:,Readers:0,LikedCount:0,BelongNO:20000000,BelongType:Company,ContactNO:10000000,UrgentRemark:3453453,CreateTime:[2016-08-20 23:53:25],UpdateTime:[2016-08-21 09:10:52],MoneyStatus:NoPayment');
INSERT INTO `event_log` VALUES ('25', 'SP_A_1', 'system', 'Update', 'Project', '2016-08-21 17:55:56', '10000000', 'ProjectNO:30000001,ProjectName:黄烈全,Region:0,Money:10000,MoneyName:,StartTime:[2016-08-02 00:00:00],EndTime:[2016-08-02 00:00:00],Entrants:10,EntrantsName:100-299,ProjectRequire:hdfgfdgdfgdfgdg,Status:Approving,BookStatus:Active,Remark:,Readers:0,LikedCount:0,BelongNO:20000000,BelongType:Company,ContactNO:10000000,UrgentRemark:3453453,CreateTime:[2016-08-20 23:53:25],UpdateTime:[2016-08-21 09:13:27],MoneyStatus:NoPayment');
INSERT INTO `event_log` VALUES ('26', 'SP_A_1', 'system', 'Update', 'Project', '2016-08-21 19:14:52', '10000000', 'ProjectNO:30000001,ProjectName:黄烈全,Region:0,Money:10000,MoneyName:,StartTime:[2016-08-02 00:00:00],EndTime:[2016-08-02 00:00:00],Entrants:10,EntrantsName:100-299,ProjectRequire:hdfgfdgdfgdfgdg,Status:Approving,BookStatus:Active,Remark:,Readers:0,LikedCount:0,BelongNO:20000000,BelongType:Company,ContactNO:10000000,UrgentRemark:3453453,CreateTime:[2016-08-20 23:53:25],UpdateTime:[2016-08-21 17:55:56],MoneyStatus:NoPayment');
INSERT INTO `event_log` VALUES ('27', 'SP_A_1', 'system', 'Update', 'Project', '2016-08-21 19:17:38', '10000000', 'ProjectNO:30000001,ProjectName:黄烈全,Region:0,Money:10000,MoneyName:,StartTime:[2016-08-02 00:00:00],EndTime:[2016-08-02 00:00:00],Entrants:50,EntrantsName:100-299,ProjectRequire:hdfgfdgdfgdfgdg,Status:Approving,BookStatus:Active,Remark:,Readers:0,LikedCount:0,BelongNO:20000000,BelongType:Company,ContactNO:10000000,UrgentRemark:3453453,CreateTime:[2016-08-20 23:53:25],UpdateTime:[2016-08-21 19:14:51],MoneyStatus:NoPayment');
INSERT INTO `event_log` VALUES ('28', 'SP_A_1', 'system', 'Update', 'Project', '2016-08-21 19:37:16', '10000000', 'ProjectNO:30000001,ProjectName:黄烈全,Region:0,Money:10000,MoneyName:,StartTime:[2016-08-02 00:00:00],EndTime:[2016-08-02 00:00:00],Entrants:10,EntrantsName:100-299,ProjectRequire:hdfgfdgdfgdfgdg,Status:Open,BookStatus:Active,Remark:,Readers:0,LikedCount:0,BelongNO:20000000,BelongType:Company,ContactNO:10000000,UrgentRemark:3453453,CreateTime:[2016-08-20 23:53:25],UpdateTime:[2016-08-21 19:17:38],MoneyStatus:NoPayment');
INSERT INTO `event_log` VALUES ('29', 'SP_A_1', 'system', 'Update', 'Project', '2016-08-21 19:39:35', '10000000', 'ProjectNO:30000001,ProjectName:黄烈全,Region:0,Money:10000,MoneyName:,StartTime:[2016-08-02 00:00:00],EndTime:[2016-08-02 00:00:00],Entrants:55,EntrantsName:100-299,ProjectRequire:hdfgfdgdfgdfgdg,Status:Open,BookStatus:Active,Remark:,Readers:0,LikedCount:0,BelongNO:20000000,BelongType:Company,ContactNO:10000000,UrgentRemark:3453453,CreateTime:[2016-08-20 23:53:25],UpdateTime:[2016-08-21 19:37:16],MoneyStatus:NoPayment');
INSERT INTO `event_log` VALUES ('30', 'SP_A_1', 'system', 'Update', 'Project', '2016-08-21 19:41:04', '10000000', 'ProjectNO:30000001,ProjectName:黄烈全,Region:0,Money:10000,MoneyName:,StartTime:[2016-08-02 00:00:00],EndTime:[2016-08-02 00:00:00],Entrants:20,EntrantsName:100-299,ProjectRequire:hdfgfdgdfgdfgdg,Status:Open,BookStatus:Active,Remark:,Readers:0,LikedCount:0,BelongNO:20000000,BelongType:Company,ContactNO:10000000,UrgentRemark:3453453,CreateTime:[2016-08-20 23:53:25],UpdateTime:[2016-08-21 19:39:35],MoneyStatus:NoPayment');
INSERT INTO `event_log` VALUES ('31', 'SP_A_1', 'system', 'Update', 'Project', '2016-08-21 19:50:38', '10000000', 'ProjectNO:30000001,ProjectName:黄烈全,Region:0,Money:10000,MoneyName:,StartTime:[2016-08-02 00:00:00],EndTime:[2016-08-02 00:00:00],Entrants:2,EntrantsName:100-299,ProjectRequire:hdfgfdgdfgdfgdg,Status:Open,BookStatus:Active,Remark:,Readers:0,LikedCount:0,BelongNO:20000000,BelongType:Company,ContactNO:10000000,UrgentRemark:3453453,CreateTime:[2016-08-20 23:53:25],UpdateTime:[2016-08-21 19:41:04],MoneyStatus:NoPayment');
INSERT INTO `event_log` VALUES ('32', 'SP_A_1', 'system', 'Update', 'Project', '2016-08-21 19:53:55', '10000000', 'ProjectNO:30000001,ProjectName:黄烈全,Region:0,Money:10000,MoneyName:,StartTime:[2016-08-02 00:00:00],EndTime:[2016-08-02 00:00:00],Entrants:22,EntrantsName:100-299,ProjectRequire:hdfgfdgdfgdfgdg,Status:Open,BookStatus:Active,Remark:,Readers:0,LikedCount:0,BelongNO:20000000,BelongType:Company,ContactNO:10000000,UrgentRemark:3453453,CreateTime:[2016-08-20 23:53:25],UpdateTime:[2016-08-21 19:50:37],MoneyStatus:NoPayment');
INSERT INTO `event_log` VALUES ('33', 'SP_A_1', 'system', 'Update', 'Project', '2016-08-21 22:16:45', '10000000', 'ProjectNO:30000001,ProjectName:黄烈全,Region:0,Money:10000,MoneyName:,StartTime:[2016-08-02 00:00:00],EndTime:[2016-08-02 00:00:00],Entrants:10,EntrantsName:100-299,ProjectRequire:hdfgfdgdfgdfgdg,Status:Open,BookStatus:Active,Remark:,Readers:0,LikedCount:0,BelongNO:20000000,BelongType:Company,ContactNO:10000000,UrgentRemark:3453453,CreateTime:[2016-08-20 23:53:25],UpdateTime:[2016-08-21 19:53:55],MoneyStatus:NoPayment');
INSERT INTO `event_log` VALUES ('34', 'SP_A_1', 'system', 'Update', 'Project', '2016-08-21 22:25:53', '10000000', 'ProjectNO:30000001,ProjectName:黄烈全,Region:0,Money:10000,MoneyName:,StartTime:[2016-08-02 00:00:00],EndTime:[2016-08-02 00:00:00],Entrants:1000,EntrantsName:100-299,ProjectRequire:hdfgfdgdfgdfgdg,Status:Open,BookStatus:Active,Remark:,Readers:0,LikedCount:0,BelongNO:20000000,BelongType:Company,ContactNO:10000000,UrgentRemark:3453453,CreateTime:[2016-08-20 23:53:25],UpdateTime:[2016-08-21 22:16:45],MoneyStatus:NoPayment');
INSERT INTO `event_log` VALUES ('35', 'SP_A_1', 'system', 'Update', 'Project', '2016-08-21 22:28:27', '10000000', 'ProjectNO:30000001,ProjectName:黄烈全,Region:0,Money:10000,MoneyName:,StartTime:[2016-08-02 00:00:00],EndTime:[2016-08-02 00:00:00],Entrants:10,EntrantsName:100-299,ProjectRequire:hdfgfdgdfgdfgdg,Status:Open,BookStatus:Active,Remark:,Readers:0,LikedCount:0,BelongNO:20000000,BelongType:Company,ContactNO:10000000,UrgentRemark:3453453,CreateTime:[2016-08-20 23:53:25],UpdateTime:[2016-08-21 22:25:53],MoneyStatus:NoPayment');
INSERT INTO `event_log` VALUES ('36', 'SP_A_1', 'system', 'Update', 'Project', '2016-08-21 22:29:22', '10000000', 'ProjectNO:30000001,ProjectName:黄烈全,Region:0,Money:10000,MoneyName:,StartTime:[2016-08-02 00:00:00],EndTime:[2016-08-02 00:00:00],Entrants:10,EntrantsName:100-299,ProjectRequire:hdfgfdgdfgdfgdg,Status:Open,BookStatus:Active,Remark:,Readers:0,LikedCount:0,BelongNO:20000000,BelongType:Company,ContactNO:10000000,UrgentRemark:3453453,CreateTime:[2016-08-20 23:53:25],UpdateTime:[2016-08-21 22:28:27],MoneyStatus:NoPayment');
INSERT INTO `event_log` VALUES ('37', 'SP_A_1', 'system', 'Update', 'Project', '2016-08-21 22:36:35', '10000000', 'ProjectNO:30000001,ProjectName:黄烈全,Region:0,Money:10000,MoneyName:,StartTime:[2016-08-02 00:00:00],EndTime:[2016-08-02 00:00:00],Entrants:10,EntrantsName:100-299,ProjectRequire:hdfgfdgdfgdfgdg,Status:Open,BookStatus:Active,Remark:,Readers:0,LikedCount:0,BelongNO:20000000,BelongType:Company,ContactNO:10000000,UrgentRemark:3453453,CreateTime:[2016-08-20 23:53:25],UpdateTime:[2016-08-21 22:29:22],MoneyStatus:NoPayment');
INSERT INTO `event_log` VALUES ('38', 'SP_A_1', 'system', 'Update', 'Project', '2016-08-21 22:49:06', '10000000', 'ProjectNO:30000001,ProjectName:黄烈全,Region:0,Money:10000,MoneyName:,StartTime:[2016-08-02 00:00:00],EndTime:[2016-08-02 00:00:00],Entrants:10,EntrantsName:100-299,ProjectRequire:hdfgfdgdfgdfgdg,Status:Open,BookStatus:Active,Remark:,Readers:0,LikedCount:0,BelongNO:20000000,BelongType:Company,ContactNO:10000000,UrgentRemark:3453453,CreateTime:[2016-08-20 23:53:25],UpdateTime:[2016-08-21 22:36:35],MoneyStatus:NoPayment');
INSERT INTO `event_log` VALUES ('39', 'SP_A_1', 'system', 'Update', 'Project', '2016-08-21 22:59:22', '10000000', 'ProjectNO:30000001,ProjectName:黄烈全,Region:0,Money:10000,MoneyName:,StartTime:[2016-08-02 00:00:00],EndTime:[2016-08-02 00:00:00],Entrants:222,EntrantsName:100-299,ProjectRequire:hdfgfdgdfgdfgdg,Status:Open,BookStatus:Active,Remark:,Readers:0,LikedCount:0,BelongNO:20000000,BelongType:Company,ContactNO:10000000,UrgentRemark:3453453,CreateTime:[2016-08-20 23:53:25],UpdateTime:[2016-08-21 22:49:06],MoneyStatus:NoPayment');
INSERT INTO `event_log` VALUES ('40', 'SP_A_1', 'system', 'Update', 'Project', '2016-08-21 23:06:52', '10000000', 'ProjectNO:30000001,ProjectName:黄烈全,Region:0,Money:10000,MoneyName:,StartTime:[2016-08-02 00:00:00],EndTime:[2016-08-02 00:00:00],Entrants:10,EntrantsName:100-299,ProjectRequire:hdfgfdgdfgdfgdg,Status:Open,BookStatus:Active,Remark:,Readers:0,LikedCount:0,BelongNO:20000000,BelongType:Company,ContactNO:10000000,UrgentRemark:3453453,CreateTime:[2016-08-20 23:53:25],UpdateTime:[2016-08-21 22:59:22],MoneyStatus:NoPayment');
INSERT INTO `event_log` VALUES ('41', 'SP_A_1', 'system', 'Update', 'Project', '2016-08-22 08:32:01', '10000000', 'ProjectNO:30000001,ProjectName:黄烈全,Region:0,Money:10000,MoneyName:,StartTime:[2016-08-02 00:00:00],EndTime:[2016-08-02 00:00:00],Entrants:10,EntrantsName:100-299,ProjectRequire:hdfgfdgdfgdfgdg,Status:Open,BookStatus:Active,Remark:,Readers:0,LikedCount:0,BelongNO:20000000,BelongType:Company,ContactNO:10000000,UrgentRemark:3453453,CreateTime:[2016-08-20 23:53:25],UpdateTime:[2016-08-21 23:06:52],MoneyStatus:NoPayment');
INSERT INTO `event_log` VALUES ('42', 'SP_A_1', 'system', 'Update', 'Project', '2016-08-22 14:47:40', '20000000', 'ProjectNO:30000001,ProjectName:现货白银赞助书,Region:0,Money:10000,MoneyName:,StartTime:[2016-08-02 00:00:00],EndTime:[2016-08-02 00:00:00],Entrants:10,EntrantsName:100-299,ProjectRequire:hdfgfdgdfgdfgdg,Status:Cancel,BookStatus:Active,Remark:1,Readers:0,LikedCount:0,BelongNO:20000000,BelongType:Company,ContactNO:10000000,UrgentRemark:3453453,CreateTime:[2016-08-20 23:53:25],UpdateTime:[2016-08-22 08:32:01],MoneyStatus:NoPayment');
INSERT INTO `event_log` VALUES ('43', 'SP_A_1', 'system', 'Update', 'Project', '2016-08-22 14:51:16', '20000000', 'ProjectNO:30000001,ProjectName:现货白银赞助书,Region:0,Money:10000,MoneyName:,StartTime:[2016-08-02 00:00:00],EndTime:[2016-08-02 00:00:00],Entrants:10,EntrantsName:100-299,ProjectRequire:hdfgfdgdfgdfgdg,Status:Cancel,BookStatus:Active,Remark:900000034,Readers:0,LikedCount:0,BelongNO:20000000,BelongType:Company,ContactNO:10000000,UrgentRemark:3453453,CreateTime:[2016-08-20 23:53:25],UpdateTime:[2016-08-22 14:47:40],MoneyStatus:NoPayment');
INSERT INTO `event_log` VALUES ('44', 'SP_A_1', 'system', 'Update', 'Project', '2016-08-22 15:02:42', '20000000', 'ProjectNO:30000001,ProjectName:现货白银赞助书,Region:0,Money:10000,MoneyName:,StartTime:[2016-08-02 00:00:00],EndTime:[2016-08-02 00:00:00],Entrants:10,EntrantsName:100-299,ProjectRequire:hdfgfdgdfgdfgdg,Status:Cancel,BookStatus:Active,Remark:活动信息错误,Readers:0,LikedCount:0,BelongNO:20000000,BelongType:Company,ContactNO:10000000,UrgentRemark:3453453,CreateTime:[2016-08-20 23:53:25],UpdateTime:[2016-08-22 14:51:16],MoneyStatus:NoPayment');
INSERT INTO `event_log` VALUES ('45', 'SP_A_1', 'system', 'Update', 'Project', '2016-08-22 15:03:48', '20000000', 'ProjectNO:30000001,ProjectName:现货白银赞助书,Region:0,Money:10000,MoneyName:,StartTime:[2016-08-02 00:00:00],EndTime:[2016-08-02 00:00:00],Entrants:10,EntrantsName:100-299,ProjectRequire:hdfgfdgdfgdfgdg,Status:Cancel,BookStatus:Active,Remark:活动信息错误,Readers:0,LikedCount:0,BelongNO:20000000,BelongType:Company,ContactNO:10000000,UrgentRemark:3453453,CreateTime:[2016-08-20 23:53:25],UpdateTime:[2016-08-22 15:02:42],MoneyStatus:NoPayment');
INSERT INTO `event_log` VALUES ('46', 'SP_A_1', 'system', 'Update', 'Project', '2016-08-23 16:19:18', '20000000', 'ProjectNO:30000001,ProjectName:现货白银赞助书,Region:0,Money:10000,MoneyName:,StartTime:[2016-08-02 00:00:00],EndTime:[2016-08-02 00:00:00],Entrants:10,EntrantsName:100-299,ProjectRequire:hdfgfdgdfgdfgdg,Status:Cancel,BookStatus:Active,Remark:活动信息错误,Readers:0,LikedCount:0,BelongNO:20000000,BelongType:Company,ContactNO:10000000,UrgentRemark:3453453,CreateTime:[2016-08-20 23:53:25],UpdateTime:[2016-08-22 15:03:48],MoneyStatus:NoPayment');
INSERT INTO `event_log` VALUES ('47', 'SP_A_1', 'system', 'Update', 'Project', '2016-08-24 15:24:08', '20000000', 'ProjectNO:30000001,ProjectName:现货白银赞助书,Region:0,Money:10000,MoneyName:,StartTime:[2016-08-02 00:00:00],EndTime:[2016-08-02 00:00:00],Entrants:10,EntrantsName:100-299,ProjectRequire:ffdsafasfsdafsdf,Status:Cancel,BookStatus:Active,Remark:活动信息错误,Readers:0,LikedCount:0,BelongNO:20000000,BelongType:Company,ContactNO:10000000,UrgentRemark:3453453,CreateTime:[2016-08-20 23:53:25],UpdateTime:[2016-08-23 16:19:18],MoneyStatus:NoPayment,ActivityAmount:0');
INSERT INTO `event_log` VALUES ('48', 'SP_A_1', 'system', 'Create', 'Project', '2016-08-24 19:10:20', '10000000', 'ProjectNO:30000004,ProjectName:毕马威中国留学赞助书,Region:0,Money:5888888,StartTime:[2016-08-16 00:00:00],EndTime:[2016-08-16 00:00:00],Entrants:900000005,EntrantsName:301-500,ProjectRequire:这是一个很好的活动，我要你们好好搞！！！！！！！,Status:Draft,BookStatus:Pending,Readers:0,LikedCount:0,BelongNO:20000000,BelongType:Company,ContactNO:10000000,UrgentRemark:黄烈全：18825195397,CreateTime:,UpdateTime:,MoneyStatus:NoPayment,ActivityAmount:0');
INSERT INTO `event_log` VALUES ('49', 'SP_A_1', 'system', 'Update', 'Project', '2016-08-24 20:22:45', '10000000', 'ProjectNO:30000004,ProjectName:毕马威中国留学赞助书,Region:0,Money:5888888,MoneyName:,StartTime:[2016-08-16 00:00:00],EndTime:[2016-08-16 00:00:00],Entrants:10,EntrantsName:301-500,ProjectRequire:这是一个很好的活动，我要你们好好搞！！！！！！！,Status:Open,BookStatus:Pending,Remark:,Readers:0,LikedCount:0,BelongNO:20000000,BelongType:Company,ContactNO:10000000,UrgentRemark:黄烈全：18825195397,CreateTime:[2016-08-24 19:10:20],UpdateTime:[2016-08-24 19:10:20],MoneyStatus:NoPayment,ActivityAmount:0');
INSERT INTO `event_log` VALUES ('50', 'SP_A_1', 'system', 'Update', 'Project', '2016-08-24 20:24:19', '10000000', 'ProjectNO:30000004,ProjectName:毕马威中国留学赞助书,Region:0,Money:5888888,MoneyName:,StartTime:[2016-08-16 00:00:00],EndTime:[2016-08-16 00:00:00],Entrants:10,EntrantsName:301-500,ProjectRequire:这是一个很好的活动，我要你们好好搞！！！！！！！,Status:Open,BookStatus:Pending,Remark:,Readers:0,LikedCount:0,BelongNO:20000000,BelongType:Company,ContactNO:10000000,UrgentRemark:黄烈全：18825195397,CreateTime:[2016-08-24 19:10:20],UpdateTime:[2016-08-24 20:22:45],MoneyStatus:NoPayment,ActivityAmount:0');
INSERT INTO `event_log` VALUES ('51', 'SP_A_1', 'system', 'Update', 'Project', '2016-08-24 20:37:00', '10000000', 'ProjectNO:30000004,ProjectName:毕马威中国留学赞助书,Region:0,Money:5888888,MoneyName:,StartTime:[2016-08-16 00:00:00],EndTime:[2016-08-16 00:00:00],Entrants:10,EntrantsName:301-500,ProjectRequire:这是一个很好的活动，我要你们好好搞！！！！！！！,Status:Open,BookStatus:Pending,Remark:,Readers:0,LikedCount:0,BelongNO:20000000,BelongType:Company,ContactNO:10000000,UrgentRemark:黄烈全：18825195397,CreateTime:[2016-08-24 19:10:20],UpdateTime:[2016-08-24 20:24:19],MoneyStatus:NoPayment,ActivityAmount:0');
INSERT INTO `event_log` VALUES ('52', 'SP_A_1', 'system', 'Update', 'Project', '2016-08-24 20:39:17', '10000000', 'ProjectNO:30000004,ProjectName:毕马威中国留学赞助书,Region:0,Money:5888888,MoneyName:,StartTime:[2016-08-16 00:00:00],EndTime:[2016-08-16 00:00:00],Entrants:1,EntrantsName:301-500,ProjectRequire:这是一个很好的活动，我要你们好好搞！！！！！！！,Status:Open,BookStatus:Pending,Remark:,Readers:0,LikedCount:0,BelongNO:20000000,BelongType:Company,ContactNO:10000000,UrgentRemark:黄烈全：18825195397,CreateTime:[2016-08-24 19:10:20],UpdateTime:[2016-08-24 20:37:00],MoneyStatus:NoPayment,ActivityAmount:0');
INSERT INTO `event_log` VALUES ('53', 'SP_A_1', 'system', 'Update', 'Project', '2016-08-24 20:45:35', '10000000', 'ProjectNO:30000004,ProjectName:毕马威中国留学赞助书,Region:0,Money:5888888,MoneyName:,StartTime:[2016-08-16 00:00:00],EndTime:[2016-08-16 00:00:00],Entrants:10,EntrantsName:301-500,ProjectRequire:这是一个很好的活动，我要你们好好搞！！！！！！！,Status:Open,BookStatus:Pending,Remark:,Readers:0,LikedCount:0,BelongNO:20000000,BelongType:Company,ContactNO:10000000,UrgentRemark:黄烈全：18825195397,CreateTime:[2016-08-24 19:10:20],UpdateTime:[2016-08-24 20:39:17],MoneyStatus:NoPayment,ActivityAmount:0');
INSERT INTO `event_log` VALUES ('54', 'SP_A_1', 'system', 'Update', 'Project', '2016-08-24 20:54:27', '10000000', 'ProjectNO:30000004,ProjectName:毕马威中国留学赞助书,Region:0,Money:5888888,MoneyName:,StartTime:[2016-08-16 00:00:00],EndTime:[2016-08-16 00:00:00],Entrants:0,EntrantsName:301-500,ProjectRequire:这是一个很好的活动，我要你们好好搞！！！！！！！,Status:Open,BookStatus:Pending,Remark:,Readers:0,LikedCount:0,BelongNO:20000000,BelongType:Company,ContactNO:10000000,UrgentRemark:黄烈全：18825195397,CreateTime:[2016-08-24 19:10:20],UpdateTime:[2016-08-24 20:45:35],MoneyStatus:NoPayment,ActivityAmount:0');
INSERT INTO `event_log` VALUES ('55', 'SP_A_1', 'system', 'Update', 'Project', '2016-08-24 20:56:33', '10000000', 'ProjectNO:30000004,ProjectName:毕马威中国留学赞助书,Region:0,Money:5888888,MoneyName:,StartTime:[2016-08-16 00:00:00],EndTime:[2016-08-16 00:00:00],Entrants:10,EntrantsName:301-500,ProjectRequire:这是一个很好的活动，我要你们好好搞！！！！！！！,Status:Open,BookStatus:Pending,Remark:,Readers:0,LikedCount:0,BelongNO:20000000,BelongType:Company,ContactNO:10000000,UrgentRemark:黄烈全：18825195397,CreateTime:[2016-08-24 19:10:20],UpdateTime:[2016-08-24 20:54:27],MoneyStatus:NoPayment,ActivityAmount:0');
INSERT INTO `event_log` VALUES ('56', 'SP_A_1', 'system', 'Update', 'Project', '2016-08-24 21:01:04', '10000000', 'ProjectNO:30000004,ProjectName:毕马威中国留学赞助书,Region:0,Money:5888888,MoneyName:,StartTime:[2016-08-16 00:00:00],EndTime:[2016-08-16 00:00:00],Entrants:10,EntrantsName:301-500,ProjectRequire:这是一个很好的活动，我要你们好好搞！！！！！！！,Status:Open,BookStatus:Pending,Remark:,Readers:0,LikedCount:0,BelongNO:20000000,BelongType:Company,ContactNO:10000000,UrgentRemark:黄烈全：18825195397,CreateTime:[2016-08-24 19:10:20],UpdateTime:[2016-08-24 20:56:33],MoneyStatus:NoPayment,ActivityAmount:0');
INSERT INTO `event_log` VALUES ('57', 'SP_A_1', 'system', 'SysError', 'SysError', '2016-08-24 21:04:05', '10000000', 'Message: The controller for path \'/enterprise/400000000\' was not found or does not implement IController.Url: /enterprise/400000000');
INSERT INTO `event_log` VALUES ('58', 'SP_A_1', 'system', 'Update', 'Project', '2016-08-24 21:08:08', '10000000', 'ProjectNO:30000004,ProjectName:毕马威中国留学赞助书,Region:0,Money:5888888,MoneyName:,StartTime:[2016-08-16 00:00:00],EndTime:[2016-08-16 00:00:00],Entrants:10,EntrantsName:301-500,ProjectRequire:这是一个很好的活动，我要你们好好搞！！！！！！！,Status:Open,BookStatus:Pending,Remark:,Readers:0,LikedCount:0,BelongNO:20000000,BelongType:Company,ContactNO:10000000,UrgentRemark:黄烈全：18825195397,CreateTime:[2016-08-24 19:10:20],UpdateTime:[2016-08-24 21:01:04],MoneyStatus:NoPayment,ActivityAmount:0');
INSERT INTO `event_log` VALUES ('59', 'SP_A_1', 'system', 'Update', 'Project', '2016-08-24 21:12:22', '10000000', 'ProjectNO:30000004,ProjectName:毕马威中国留学赞助书,Region:0,Money:5888888,MoneyName:,StartTime:[2016-08-16 00:00:00],EndTime:[2016-08-16 00:00:00],Entrants:20,EntrantsName:301-500,ProjectRequire:这是一个很好的活动，我要你们好好搞！！！！！！！,Status:Open,BookStatus:Pending,Remark:,Readers:0,LikedCount:0,BelongNO:20000000,BelongType:Company,ContactNO:10000000,UrgentRemark:黄烈全：18825195397,CreateTime:[2016-08-24 19:10:20],UpdateTime:[2016-08-24 21:08:08],MoneyStatus:NoPayment,ActivityAmount:0');
INSERT INTO `event_log` VALUES ('60', 'SP_A_1', 'system', 'Create', 'Project', '2016-08-24 23:13:50', '10000000', 'ProjectNO:30000005,ProjectName:中国移动赞助书,Region:0,Money:8888,StartTime:[2016-08-01 00:00:00],EndTime:[2016-09-10 00:00:00],Entrants:900000006,EntrantsName:501-1000,ProjectRequire:中国移动牛逼，中国移动万岁,Status:Draft,BookStatus:Pending,Readers:0,LikedCount:0,BelongNO:20000000,BelongType:Company,ContactNO:10000000,UrgentRemark:黄烈全：18825195397,CreateTime:,UpdateTime:,MoneyStatus:NoPayment,ActivityAmount:0');
INSERT INTO `event_log` VALUES ('61', 'SP_A_1', 'system', 'Create', 'Project', '2016-08-24 23:18:24', '10000000', 'ProjectNO:30000006,ProjectName:唱出宇宙赞助书,Region:0,Money:55555,StartTime:[2016-08-10 00:00:00],EndTime:[2016-09-10 00:00:00],Entrants:900000004,EntrantsName:101-300,ProjectRequire:好好搞，不会亏待你们,Status:Draft,BookStatus:Pending,Readers:0,LikedCount:0,BelongNO:20000000,BelongType:Company,ContactNO:10000000,UrgentRemark:杨志兵：18825195397,CreateTime:,UpdateTime:,MoneyStatus:NoPayment,ActivityAmount:0');
INSERT INTO `event_log` VALUES ('62', 'SP_A_1', 'system', 'Create', 'Project', '2016-08-24 23:21:24', '10000000', 'ProjectNO:30000007,ProjectName:我爱你中国赞助书,Region:0,Money:66666,StartTime:[2016-08-17 00:00:00],EndTime:[2016-08-16 00:00:00],Entrants:900000003,EntrantsName:0-100,ProjectRequire:我爱你中国赞助书方案要求,Status:Draft,BookStatus:Pending,Readers:0,LikedCount:0,BelongNO:20000000,BelongType:Company,ContactNO:10000000,UrgentRemark:李晓波：1882254552,CreateTime:,UpdateTime:,MoneyStatus:NoPayment,ActivityAmount:0');
INSERT INTO `event_log` VALUES ('63', 'SP_A_1', 'system', 'Create', 'Project', '2016-08-24 23:22:42', '10000000', 'ProjectNO:30000008,ProjectName:黄烈全赞助书,Region:0,Money:665656,StartTime:[2016-08-09 00:00:00],EndTime:[2016-08-10 00:00:00],Entrants:900000007,EntrantsName:1001-1500,ProjectRequire:都是好的要求,Status:Draft,BookStatus:Pending,Readers:0,LikedCount:0,BelongNO:20000000,BelongType:Company,ContactNO:10000000,UrgentRemark:全都是泡沫,CreateTime:,UpdateTime:,MoneyStatus:NoPayment,ActivityAmount:0');

-- ----------------------------
-- Table structure for file_system
-- ----------------------------
DROP TABLE IF EXISTS `file_system`;
CREATE TABLE `file_system` (
  `File_NO` int(10) NOT NULL AUTO_INCREMENT,
  `Fun` varchar(50) DEFAULT NULL,
  `Type_Name` varchar(200) DEFAULT NULL,
  `InstanceID` varchar(30) DEFAULT NULL,
  `Path` varchar(500) DEFAULT NULL,
  `Status` varchar(60) DEFAULT NULL,
  `Ctreate_Time` datetime DEFAULT NULL,
  `Create_User` int(200) DEFAULT NULL,
  `Old_Name` varchar(300) DEFAULT NULL,
  `New_Name` varchar(300) DEFAULT NULL,
  `Belong_NO` int(15) DEFAULT NULL,
  PRIMARY KEY (`File_NO`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of file_system
-- ----------------------------
INSERT INTO `file_system` VALUES ('1', 'IDFront', 'Company', 'SP_A_1', 'http://localhost:58486/document/Company/20000000/IDFront20160820202057.jpg', 'Active', '2016-08-20 20:20:58', '20000000', 'IMG_20160627_183046.jpg', 'IDFront20160820202057.jpg', null);
INSERT INTO `file_system` VALUES ('2', 'IDOpposite', 'Company', 'SP_A_1', 'http://localhost:58486/document/Company/20000000/IDOpposite20160820202057.jpg', 'Active', '2016-08-20 20:20:58', '20000000', 'IMG_20160625_182302.jpg', 'IDOpposite20160820202057.jpg', null);
INSERT INTO `file_system` VALUES ('3', 'License', 'Company', 'SP_A_1', 'http://localhost:58486/document/Company/20000000/License20160820202128.jpg', 'Active', '2016-08-20 20:21:28', '20000000', 'IMG_20160627_203507.jpg', 'License20160820202128.jpg', null);
INSERT INTO `file_system` VALUES ('4', 'SponsorBook', 'Company', 'SP_A_1', 'http://localhost:58486/document/Company/20000000/SponsorBook20160820202906.jpg', 'Active', '2016-08-20 20:29:07', '20000000', 'IMG_20160613_080451.jpg', 'SponsorBook20160820202906.jpg', null);
INSERT INTO `file_system` VALUES ('5', 'SponsorBook', 'Company', 'SP_A_1', 'http://localhost:58486/document/Company/20000000/SponsorBook20160820235325.jpg', 'Active', '2016-08-20 23:53:26', '20000000', 'IMG_20160613_080438.jpg', 'SponsorBook20160820235325.jpg', null);
INSERT INTO `file_system` VALUES ('6', 'SponsorBook', 'Company', 'SP_A_1', 'http://localhost:58486/document/Company/20000000/SponsorBook20160821001759.jpg', 'Active', '2016-08-21 00:17:59', '20000000', '15913994_mh1467459197242.jpg', 'SponsorBook20160821001759.jpg', null);
INSERT INTO `file_system` VALUES ('7', 'SponsorBook', 'Project', 'SP_A_1', 'http://localhost:58486/document/Company/20000000/SponsorBook20160824191020.jpg', 'Active', '2016-08-24 19:10:20', '20000000', 'Chrysanthemum.jpg', 'SponsorBook20160824191020.jpg', '30000004');
INSERT INTO `file_system` VALUES ('8', 'SponsorBook', 'Project', 'SP_A_1', 'http://localhost:58486/document/Company/20000000/SponsorBook20160824231351.jpg', 'Active', '2016-08-24 23:13:52', '20000000', 'Chrysanthemum.jpg', 'SponsorBook20160824231351.jpg', '30000005');
INSERT INTO `file_system` VALUES ('9', 'SponsorBook', 'Project', 'SP_A_1', 'http://localhost:58486/document/Company/20000000/SponsorBook20160824231825.jpg', 'Active', '2016-08-24 23:18:25', '20000000', 'Jellyfish.jpg', 'SponsorBook20160824231825.jpg', '30000006');
INSERT INTO `file_system` VALUES ('10', 'SponsorBook', 'Project', 'SP_A_1', 'http://localhost:58486/document/Company/20000000/SponsorBook20160824232124.jpg', 'Active', '2016-08-24 23:21:24', '20000000', 'Jellyfish.jpg', 'SponsorBook20160824232124.jpg', '30000007');
INSERT INTO `file_system` VALUES ('11', 'SponsorBook', 'Project', 'SP_A_1', 'http://localhost:58486/document/Company/20000000/SponsorBook20160824232242.jpg', 'Active', '2016-08-24 23:22:43', '20000000', 'Jellyfish.jpg', 'SponsorBook20160824232242.jpg', '30000008');

-- ----------------------------
-- Table structure for level_rule
-- ----------------------------
DROP TABLE IF EXISTS `level_rule`;
CREATE TABLE `level_rule` (
  `Rule_NO` int(10) NOT NULL AUTO_INCREMENT,
  `Fun` varchar(30) DEFAULT NULL,
  `Status` varchar(60) DEFAULT NULL,
  `Value_From` varchar(60) DEFAULT NULL,
  `Value_To` varchar(60) DEFAULT NULL,
  `Level` varchar(120) DEFAULT NULL,
  `Version` int(10) DEFAULT NULL,
  `Description` varchar(255) DEFAULT NULL,
  `Parent_No` int(10) DEFAULT NULL,
  `DisplayOrder` int(4) DEFAULT NULL,
  PRIMARY KEY (`Rule_NO`)
) ENGINE=InnoDB AUTO_INCREMENT=900000171 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of level_rule
-- ----------------------------
INSERT INTO `level_rule` VALUES ('900000001', 'Nature', 'Active', '', '', '校级', null, '校级', null, null);
INSERT INTO `level_rule` VALUES ('900000002', 'Nature', 'Active', '', '', '院级', null, '院级', null, null);
INSERT INTO `level_rule` VALUES ('900000003', 'StudentInterval', 'Active', '0', '100', '1-100', null, '1-100', null, null);
INSERT INTO `level_rule` VALUES ('900000004', 'StudentInterval', 'Active', '101', '300', '101-300', null, '101-300', null, null);
INSERT INTO `level_rule` VALUES ('900000005', 'StudentInterval', 'Active', '301', '500', '301-500', null, '301-500', null, null);
INSERT INTO `level_rule` VALUES ('900000006', 'StudentInterval', 'Active', '501', '1000', '501-1000', null, '501-1000', null, null);
INSERT INTO `level_rule` VALUES ('900000007', 'StudentInterval', 'Active', '1001', '1500', '1001-1500', null, '1001-1500', null, null);
INSERT INTO `level_rule` VALUES ('900000008', 'StudentInterval', 'Active', '1501', '2500', '1501-2500', null, '1501-2500', null, null);
INSERT INTO `level_rule` VALUES ('900000009', 'StudentInterval', 'Active', '2501', '3000', '2501-3000', null, '2501-3000', null, null);
INSERT INTO `level_rule` VALUES ('900000010', 'StudentInterval', 'Active', '3000', '3000000000', '3000以上', null, '3000以上', null, null);
INSERT INTO `level_rule` VALUES ('900000011', 'SponsorMoney', 'Active', '500', '2500', '500-2500', null, '500-2500', null, null);
INSERT INTO `level_rule` VALUES ('900000012', 'SponsorMoney', 'Active', '2501', '5000', '2501-5000', null, '2501-5000', null, null);
INSERT INTO `level_rule` VALUES ('900000013', 'SponsorMoney', 'Active', '5001', '7500', '5001-7500', null, '5001-7500', null, null);
INSERT INTO `level_rule` VALUES ('900000014', 'SponsorMoney', 'Active', '7501', '10000', '7501-10000', null, '7501-10000', null, null);
INSERT INTO `level_rule` VALUES ('900000015', 'SponsorMoney', 'Active', '10001', '15000', '10001-15000', null, '10001-15000', null, null);
INSERT INTO `level_rule` VALUES ('900000016', 'SponsorMoney', 'Active', '15001', '20000', '15001-20000', null, '15001-20000', null, null);
INSERT INTO `level_rule` VALUES ('900000017', 'SponsorMoney', 'Active', '20001', '25000', '20001-25000', null, '20001-25000', null, null);
INSERT INTO `level_rule` VALUES ('900000018', 'SponsorMoney', 'Active', '25001', '30000', '25001-30000', null, '25001-30000', null, null);
INSERT INTO `level_rule` VALUES ('900000019', 'SponsorMoney', 'Active', '30001', '50000', '30001-50000', null, '30001-50000', null, null);
INSERT INTO `level_rule` VALUES ('900000020', 'SponsorMoney', 'Active', '50001', '70000', '50001-70000', null, '50001-70000', null, null);
INSERT INTO `level_rule` VALUES ('900000021', 'SponsorMoney', 'Active', '70001', '100000', '70001-100000', null, '70001-100000', null, null);
INSERT INTO `level_rule` VALUES ('900000022', 'SponsorMoney', 'Active', '100001', '150000', '100001-150000', null, '100001-150000', null, null);
INSERT INTO `level_rule` VALUES ('900000023', 'SponsorMoney', 'Active', '150001', '200000', '150001-200000', null, '150001-200000', null, null);
INSERT INTO `level_rule` VALUES ('900000024', 'SponsorMoney', 'Active', '200000', '200000000', '200000以上', null, '200000以上', null, null);
INSERT INTO `level_rule` VALUES ('900000025', 'StudentLevel', 'Active', '', '', '官方代理社团', null, '官方代理社团', null, null);
INSERT INTO `level_rule` VALUES ('900000026', 'StudentLevel', 'Active', '500', '5000000', '金牌社团', null, '金牌社团', null, null);
INSERT INTO `level_rule` VALUES ('900000027', 'StudentLevel', 'Active', '400', '500', '银牌社团', null, '银牌社团', null, null);
INSERT INTO `level_rule` VALUES ('900000028', 'StudentLevel', 'Active', '300', '400', '铜牌社团', null, '铜牌社团', null, null);
INSERT INTO `level_rule` VALUES ('900000029', 'StudentLevel', 'Active', '200', '300', '普通社团V3', null, '普通社团V3', null, null);
INSERT INTO `level_rule` VALUES ('900000030', 'StudentLevel', 'Active', '100', '200', '普通社团V2', null, '普通社团V2', null, null);
INSERT INTO `level_rule` VALUES ('900000031', 'StudentLevel', 'Active', '0', '100', '普通社团V1', null, '普通社团V1', null, null);
INSERT INTO `level_rule` VALUES ('900000032', 'SponsorMoney', 'Active', '', '', '2000', null, '2000', null, null);
INSERT INTO `level_rule` VALUES ('900000033', 'SponsorMultiple', 'Active', '', '', '5', null, '5', null, null);
INSERT INTO `level_rule` VALUES ('900000034', 'CancelRemark', 'Active', '', '', '活动信息错误', null, '活动信息错误', null, null);
INSERT INTO `level_rule` VALUES ('900000035', 'CancelRemark', 'Active', '', '', '活动长时间没收到邀请', null, '活动长时间没收到邀请', null, null);
INSERT INTO `level_rule` VALUES ('900000036', 'CancelRemark', 'Active', '', '', '活动需要重新发布', null, '活动需要重新发布', null, null);
INSERT INTO `level_rule` VALUES ('900000037', 'CancelRemark', 'Active', '', '', '活动已达成目的', null, '活动已达成目的', null, null);
INSERT INTO `level_rule` VALUES ('900000038', 'CancelRemark', 'Active', '', '', '活动时间过期', null, '活动时间过期', null, null);
INSERT INTO `level_rule` VALUES ('900000039', 'CancelRemark', 'Active', '', '', '用户自主下架', null, '用户自主下架', null, null);
INSERT INTO `level_rule` VALUES ('900000040', 'ActivityType', 'Active', '', '', '招新类', null, '招新类', null, null);
INSERT INTO `level_rule` VALUES ('900000041', 'ActivityType', 'Active', '', '', '文艺类', null, '文艺类', null, null);
INSERT INTO `level_rule` VALUES ('900000042', 'ActivityType', 'Active', '', '', '表演类', null, '表演类', null, null);
INSERT INTO `level_rule` VALUES ('900000043', 'ActivityType', 'Active', '', '', '晚会类 ', null, '晚会类 ', null, null);
INSERT INTO `level_rule` VALUES ('900000044', 'ActivityType', 'Active', '', '', '体育类', null, '体育类', null, null);
INSERT INTO `level_rule` VALUES ('900000045', 'ActivityType', 'Active', '', '', '讲座类', null, '讲座类', null, null);
INSERT INTO `level_rule` VALUES ('900000046', 'ActivityType', 'Active', '', '', '比赛类', null, '比赛类', null, null);
INSERT INTO `level_rule` VALUES ('900000047', 'ActivityType', 'Active', '', '', '其它', null, '其它', null, null);
INSERT INTO `level_rule` VALUES ('900000048', 'AssosiationType', 'Active', '', '', '组织类-学生会', null, '组织类-学生会', null, null);
INSERT INTO `level_rule` VALUES ('900000049', 'AssosiationType', 'Active', '', '', '组织类-团委', null, '组织类-团委', null, null);
INSERT INTO `level_rule` VALUES ('900000050', 'AssosiationType', 'Active', '', '', '组织类-社团联合会', null, '组织类-社团联合会', null, null);
INSERT INTO `level_rule` VALUES ('900000051', 'AssosiationType', 'Active', '', '', '组织类-其他', null, '组织类-其他', null, null);
INSERT INTO `level_rule` VALUES ('900000052', 'AssosiationType', 'Active', '', '', '社团类-青年志愿者服务队', null, '社团类-青年志愿者服务队', null, null);
INSERT INTO `level_rule` VALUES ('900000053', 'AssosiationType', 'Active', '', '', '社团类-红十字会', null, '社团类-红十字会', null, null);
INSERT INTO `level_rule` VALUES ('900000054', 'AssosiationType', 'Active', '', '', '社团类-体育类社团', null, '社团类-体育类社团', null, null);
INSERT INTO `level_rule` VALUES ('900000055', 'AssosiationType', 'Active', '', '', '社团类-棋牌类社团', null, '社团类-棋牌类社团', null, null);
INSERT INTO `level_rule` VALUES ('900000056', 'AssosiationType', 'Active', '', '', '社团类-动漫社', null, '社团类-动漫社', null, null);
INSERT INTO `level_rule` VALUES ('900000057', 'AssosiationType', 'Active', '', '', '社团类-文娱类社团', null, '社团类-文娱类社团', null, null);
INSERT INTO `level_rule` VALUES ('900000058', 'AssosiationType', 'Active', '', '', '社团类-兴趣类社团', null, '社团类-兴趣类社团', null, null);
INSERT INTO `level_rule` VALUES ('900000059', 'AssosiationType', 'Active', '', '', '社团类-其他社团', null, '社团类-其他社团', null, null);
INSERT INTO `level_rule` VALUES ('900000060', 'CompanyMaterial', 'Active', '', '', '公司产品', null, '公司产品', null, null);
INSERT INTO `level_rule` VALUES ('900000061', 'CompanyMaterial', 'Active', '', '', '传单 ', null, '传单 ', null, null);
INSERT INTO `level_rule` VALUES ('900000062', 'CompanyMaterial', 'Active', '', '', '音箱', null, '音箱', null, null);
INSERT INTO `level_rule` VALUES ('900000063', 'CompanyMaterial', 'Active', '', '', '横幅', null, '横幅', null, null);
INSERT INTO `level_rule` VALUES ('900000064', 'CompanyMaterial', 'Active', '', '', '帐篷', null, '帐篷', null, null);
INSERT INTO `level_rule` VALUES ('900000065', 'CompanyMaterial', 'Active', '', '', '桌椅', null, '桌椅', null, null);
INSERT INTO `level_rule` VALUES ('900000066', 'CompanyMaterial', 'Active', '', '', '活动展架', null, '活动展架', null, null);
INSERT INTO `level_rule` VALUES ('900000067', 'CompanyMaterial', 'Active', '', '', '活动海报', null, '活动海报', null, null);
INSERT INTO `level_rule` VALUES ('900000068', 'CompanyMaterial', 'Active', '', '', '其他', null, '其他', null, null);
INSERT INTO `level_rule` VALUES ('900000069', 'AssociationMaterial', 'Active', '', '', '横幅', null, '横幅', null, null);
INSERT INTO `level_rule` VALUES ('900000070', 'AssociationMaterial', 'Active', '', '', '传单(黑白，彩色)', null, '传单(黑白，彩色)', null, null);
INSERT INTO `level_rule` VALUES ('900000071', 'AssociationMaterial', 'Active', '', '', 'KT板', null, 'KT板', null, null);
INSERT INTO `level_rule` VALUES ('900000072', 'AssociationMaterial', 'Active', '', '', '幕布', null, '幕布', null, null);
INSERT INTO `level_rule` VALUES ('900000073', 'AssociationMaterial', 'Active', '', '', '易拉宝', null, '易拉宝', null, null);
INSERT INTO `level_rule` VALUES ('900000074', 'AssociationMaterial', 'Active', '', '', '推头', null, '推头', null, null);
INSERT INTO `level_rule` VALUES ('900000075', 'AssociationMaterial', 'Active', '', '', '灯布', null, '灯布', null, null);
INSERT INTO `level_rule` VALUES ('900000076', 'AssociationMaterial', 'Active', '', '', '木构', null, '木构', null, null);
INSERT INTO `level_rule` VALUES ('900000077', 'AssociationMaterial', 'Active', '', '', '展位', null, '展位', null, null);
INSERT INTO `level_rule` VALUES ('900000078', 'AssociationMaterial', 'Active', '', '', '灯箱', null, '灯箱', null, null);
INSERT INTO `level_rule` VALUES ('900000079', 'AssociationMaterial', 'Active', '', '', '桁架', null, '桁架', null, null);
INSERT INTO `level_rule` VALUES ('900000080', 'AssociationMaterial', 'Active', '', '', '麦克风(耳麦，手麦，麦架)', null, '麦克风(耳麦，手麦，麦架)', null, null);
INSERT INTO `level_rule` VALUES ('900000081', 'AssociationMaterial', 'Active', '', '', '帐篷', null, '帐篷', null, null);
INSERT INTO `level_rule` VALUES ('900000082', 'AssociationMaterial', 'Active', '', '', '桌椅', null, '桌椅', null, null);
INSERT INTO `level_rule` VALUES ('900000083', 'AssociationMaterial', 'Active', '', '', '音箱', null, '音箱', null, null);
INSERT INTO `level_rule` VALUES ('900000084', 'AssociationMaterial', 'Active', '', '', '活动展架', null, '活动展架', null, null);
INSERT INTO `level_rule` VALUES ('900000085', 'AssociationMaterial', 'Active', '', '', '活动海报', null, '活动海报', null, null);
INSERT INTO `level_rule` VALUES ('900000086', 'AssociationMaterial', 'Active', '', '', '其他', null, '其他', null, null);
INSERT INTO `level_rule` VALUES ('900000087', 'CheckCompanyRejectedRemark', 'Active', '', '', '不存在您所输入的代理官口号令', null, '不存在您所输入的代理官口号令', null, null);
INSERT INTO `level_rule` VALUES ('900000088', 'CheckCompanyRejectedRemark', 'Active', '', '', '企业全称与营业执照上的不一致', null, '企业全称与营业执照上的不一致', null, null);
INSERT INTO `level_rule` VALUES ('900000089', 'CheckCompanyRejectedRemark', 'Active', '', '', '企业地址不详细', null, '企业地址不详细', null, null);
INSERT INTO `level_rule` VALUES ('900000090', 'CheckCompanyRejectedRemark', 'Active', '', '', '企业网址无法正常打开或网站内容不全', null, '企业网址无法正常打开或网站内容不全', null, null);
INSERT INTO `level_rule` VALUES ('900000091', 'CheckCompanyRejectedRemark', 'Active', '', '', '注册人姓名与身份证不一致', null, '注册人姓名与身份证不一致', null, null);
INSERT INTO `level_rule` VALUES ('900000092', 'CheckCompanyRejectedRemark', 'Active', '', '', '未上传正确的身份证', null, '未上传正确的身份证', null, null);
INSERT INTO `level_rule` VALUES ('900000093', 'CheckCompanyRejectedRemark', 'Active', '', '', '执照名称或注册号与营业执照不一致', null, '执照名称或注册号与营业执照不一致', null, null);
INSERT INTO `level_rule` VALUES ('900000094', 'CheckCompanyRejectedRemark', 'Active', '', '', '未上传正确的营业执照', null, '未上传正确的营业执照', null, null);
INSERT INTO `level_rule` VALUES ('900000095', 'CheckCompanyRejectedRemark', 'Active', '', '', '邮箱未验证', null, '邮箱未验证', null, null);
INSERT INTO `level_rule` VALUES ('900000096', 'CheckAssociationRejectedRemark', 'Active', '', '', '所属院系不正确或不存在', null, '所属院系不正确或不存在', null, null);
INSERT INTO `level_rule` VALUES ('900000097', 'CheckAssociationRejectedRemark', 'Active', '', '', '注册人姓名与身份证不一致', null, '注册人姓名与身份证不一致', null, null);
INSERT INTO `level_rule` VALUES ('900000098', 'CheckAssociationRejectedRemark', 'Active', '', '', '注册人学号与学生证不一致', null, '注册人学号与学生证不一致', null, null);
INSERT INTO `level_rule` VALUES ('900000099', 'CheckAssociationRejectedRemark', 'Active', '', '', '邮箱未验证', null, '邮箱未验证', null, null);
INSERT INTO `level_rule` VALUES ('900000100', 'CheckAssociationRejectedRemark', 'Active', '', '', '未上传正确的身份证', null, '未上传正确的身份证', null, null);
INSERT INTO `level_rule` VALUES ('900000101', 'CheckAssociationRejectedRemark', 'Active', '', '', '未上传正确的学生证', null, '未上传正确的学生证', null, null);
INSERT INTO `level_rule` VALUES ('900000102', 'AssociationSize', 'Active', '1', '10', '1-10人', null, '1-10人', null, null);
INSERT INTO `level_rule` VALUES ('900000103', 'AssociationSize', 'Active', '11', '30', '11-30人', null, '11-30人', null, null);
INSERT INTO `level_rule` VALUES ('900000104', 'AssociationSize', 'Active', '31', '60', '31-60人', null, '31-60人', null, null);
INSERT INTO `level_rule` VALUES ('900000105', 'AssociationSize', 'Active', '61', '90', '61-90人', null, '61-90人', null, null);
INSERT INTO `level_rule` VALUES ('900000106', 'AssociationSize', 'Active', '91', '120', '91-120人', null, '91-120人', null, null);
INSERT INTO `level_rule` VALUES ('900000107', 'AssociationSize', 'Active', '121', '150', '121-150人', null, '121-150人', null, null);
INSERT INTO `level_rule` VALUES ('900000108', 'AssociationSize', 'Active', '151', '200', '151-200人', null, '151-200人', null, null);
INSERT INTO `level_rule` VALUES ('900000109', 'AssociationSize', 'Active', '201', '250', '201-250人', null, '201-250人', null, null);
INSERT INTO `level_rule` VALUES ('900000110', 'AssociationSize', 'Active', '251', '300', '251-300人', null, '251-300人', null, null);
INSERT INTO `level_rule` VALUES ('900000111', 'AssociationSize', 'Active', '300', '1000000', '300以上', null, '300以上', null, null);
INSERT INTO `level_rule` VALUES ('900000112', 'AssociationSchoolType', 'Active', '', '', '组织类', null, '组织类', null, null);
INSERT INTO `level_rule` VALUES ('900000113', 'AssociationSchoolType', 'Active', '', '', '社团类', null, '社团类', null, null);
INSERT INTO `level_rule` VALUES ('900000114', 'AssociationRejectRemark', 'Active', '', '', '信息不匹配', null, '信息不匹配', null, null);
INSERT INTO `level_rule` VALUES ('900000115', 'AssociationRejectRemark', 'Active', '', '', '企业赞助金不适合', null, '企业赞助金不适合', null, null);
INSERT INTO `level_rule` VALUES ('900000116', 'AssociationRejectRemark', 'Active', '', '', '企业所在地不是所需所在地 ', null, '企业所在地不是所需所在地 ', null, null);
INSERT INTO `level_rule` VALUES ('900000117', 'AssociationRejectRemark', 'Active', '', '', '已受邀于其他企业赞助', null, '已受邀于其他企业赞助', null, null);
INSERT INTO `level_rule` VALUES ('900000118', 'AssociationRejectRemark', 'Active', '', '', '其他', null, '其他', null, null);
INSERT INTO `level_rule` VALUES ('900000119', 'CompanyRejectRemark', 'Active', '', '', '信息不匹配', null, '信息不匹配', null, null);
INSERT INTO `level_rule` VALUES ('900000120', 'CompanyRejectRemark', 'Active', '', '', '社团规模太小', null, '社团规模太小', null, null);
INSERT INTO `level_rule` VALUES ('900000121', 'CompanyRejectRemark', 'Active', '', '', '社团所在地不是所需所在地 ', null, '社团所在地不是所需所在地 ', null, null);
INSERT INTO `level_rule` VALUES ('900000122', 'CompanyRejectRemark', 'Active', '', '', '已受邀于其他社团活动', null, '已受邀于其他社团活动', null, null);
INSERT INTO `level_rule` VALUES ('900000123', 'CompanyRejectRemark', 'Active', '', '', '其他', null, '其他', null, null);
INSERT INTO `level_rule` VALUES ('900000124', 'AssociationProjectReject', 'Active', '', '', '信息不正确', null, '信息不正确', null, null);
INSERT INTO `level_rule` VALUES ('900000125', 'AssociationProjectReject', 'Active', '', '', '活动名称错误', null, '活动名称错误', null, null);
INSERT INTO `level_rule` VALUES ('900000126', 'AssociationProjectReject', 'Active', '', '', '活动所需金额超过限定范围', null, '活动所需金额超过限定范围', null, null);
INSERT INTO `level_rule` VALUES ('900000127', 'AssociationProjectReject', 'Active', '', '', '社团活动书所属社团已达到3个合作中的合同', null, '社团活动书所属社团已达到3个合作中的合同', null, null);
INSERT INTO `level_rule` VALUES ('900000128', 'CompanyProjectReject', 'Active', '', '', '信息不正确', null, '信息不正确', null, null);
INSERT INTO `level_rule` VALUES ('900000129', 'CompanyProjectReject', 'Active', '', '', '活动名称错误', null, '活动名称错误', null, null);
INSERT INTO `level_rule` VALUES ('900000130', 'CompanyProjectReject', 'Active', '', '', '赞助提供金额超出平台限定', null, '赞助提供金额超出平台限定', null, null);
INSERT INTO `level_rule` VALUES ('900000131', 'CompanyProjectReject', 'Active', '', '', '赞助时间过长', null, '赞助时间过长', null, null);
INSERT INTO `level_rule` VALUES ('900000132', 'AgentReward', 'Active', '0', '5000', '赞助金的8%', null, '赞助金的8%', null, null);
INSERT INTO `level_rule` VALUES ('900000133', 'AgentReward', 'Active', '5001', '10000', '赞助金的8.5%', null, '赞助金的8.5%', null, null);
INSERT INTO `level_rule` VALUES ('900000134', 'AgentReward', 'Active', '10001', '15000', '赞助金的9%', null, '赞助金的9%', null, null);
INSERT INTO `level_rule` VALUES ('900000135', 'AgentReward', 'Active', '15001', '20000', '赞助金的9.5%', null, '赞助金的9.5%', null, null);
INSERT INTO `level_rule` VALUES ('900000136', 'AgentReward', 'Active', '20001', '200000000', '赞助金的10%', null, '赞助金的10%', null, null);
INSERT INTO `level_rule` VALUES ('900000137', 'CompanyType', 'Active', '', '', '外资独资（欧美企业）', null, '外资独资（欧美企业）', null, null);
INSERT INTO `level_rule` VALUES ('900000138', 'CompanyType', 'Active', '', '', '外资独资（非欧美企业）', null, '外资独资（非欧美企业）', null, null);
INSERT INTO `level_rule` VALUES ('900000139', 'CompanyType', 'Active', '', '', '合资/合作（欧美企业）', null, '合资/合作（欧美企业）', null, null);
INSERT INTO `level_rule` VALUES ('900000140', 'CompanyType', 'Active', '', '', '合资/合作（非欧美企业）', null, '合资/合作（非欧美企业）', null, null);
INSERT INTO `level_rule` VALUES ('900000141', 'CompanyType', 'Active', '', '', '国营企业/上市企业', null, '国营企业/上市企业', null, null);
INSERT INTO `level_rule` VALUES ('900000142', 'CompanyType', 'Active', '', '', '民营/私营企业/非上市企业', null, '民营/私营企业/非上市企业', null, null);
INSERT INTO `level_rule` VALUES ('900000143', 'CompanyType', 'Active', '', '', '外企代表处', null, '外企代表处', null, null);
INSERT INTO `level_rule` VALUES ('900000144', 'CompanyType', 'Active', '', '', '其他', null, '其他', null, null);
INSERT INTO `level_rule` VALUES ('900000145', 'CompanySize', 'Active', '0', '50', '小于50人', null, '小于50人', null, null);
INSERT INTO `level_rule` VALUES ('900000146', 'CompanySize', 'Active', '50', '150', '50-150', null, '50-150', null, null);
INSERT INTO `level_rule` VALUES ('900000147', 'CompanySize', 'Active', '151', '500', '151-500', null, '151-500', null, null);
INSERT INTO `level_rule` VALUES ('900000148', 'CompanySize', 'Active', '501', '2000', '501-2000', null, '501-2000', null, null);
INSERT INTO `level_rule` VALUES ('900000149', 'CompanySize', 'Active', '2000', '', '2000以上', null, '2000以上', null, null);
INSERT INTO `level_rule` VALUES ('900000150', 'CompanyIndustry', 'Active', '', '', '家电', null, '家电', null, null);
INSERT INTO `level_rule` VALUES ('900000151', 'CompanyIndustry', 'Active', '', '', '通讯', null, '通讯', null, null);
INSERT INTO `level_rule` VALUES ('900000152', 'CompanyIndustry', 'Active', '', '', '房产建材', null, '房产建材', null, null);
INSERT INTO `level_rule` VALUES ('900000153', 'CompanyIndustry', 'Active', '', '', '医疗保健', null, '医疗保健', null, null);
INSERT INTO `level_rule` VALUES ('900000154', 'CompanyIndustry', 'Active', '', '', '工业制造', null, '工业制造', null, null);
INSERT INTO `level_rule` VALUES ('900000155', 'CompanyIndustry', 'Active', '', '', '现代服务', null, '现代服务', null, null);
INSERT INTO `level_rule` VALUES ('900000156', 'CompanyIndustry', 'Active', '', '', '日用消费品', null, '日用消费品', null, null);
INSERT INTO `level_rule` VALUES ('900000157', 'CompanyIndustry', 'Active', '', '', '酒店餐饮', null, '酒店餐饮', null, null);
INSERT INTO `level_rule` VALUES ('900000158', 'CompanyIndustry', 'Active', '', '', '食品饮料', null, '食品饮料', null, null);
INSERT INTO `level_rule` VALUES ('900000159', 'CompanyIndustry', 'Active', '', '', '化妆', null, '化妆', null, null);
INSERT INTO `level_rule` VALUES ('900000160', 'CompanyIndustry', 'Active', '', '', '汽车', null, '汽车', null, null);
INSERT INTO `level_rule` VALUES ('900000161', 'CompanyIndustry', 'Active', '', '', '服装', null, '服装', null, null);
INSERT INTO `level_rule` VALUES ('900000162', 'CompanyIndustry', 'Active', '', '', '奢饰品', null, '奢饰品', null, null);
INSERT INTO `level_rule` VALUES ('900000163', 'CompanyIndustry', 'Active', '', '', 'IT', null, 'IT', null, null);
INSERT INTO `level_rule` VALUES ('900000164', 'CompanyIndustry', 'Active', '', '', '珠宝饰品', null, '珠宝饰品', null, null);
INSERT INTO `level_rule` VALUES ('900000165', 'CompanyIndustry', 'Active', '', '', '广告企业', null, '广告企业', null, null);
INSERT INTO `level_rule` VALUES ('900000166', 'CompanyIndustry', 'Active', '', '', '烟酒类', null, '烟酒类', null, null);
INSERT INTO `level_rule` VALUES ('900000167', 'CompanyIndustry', 'Active', '', '', '金融', null, '金融', null, null);
INSERT INTO `level_rule` VALUES ('900000168', 'CompanyIndustry', 'Active', '', '', '旅游航空', null, '旅游航空', null, null);
INSERT INTO `level_rule` VALUES ('900000169', 'CompanyIndustry', 'Active', '', '', '其他', null, '其他', null, null);
INSERT INTO `level_rule` VALUES ('900000170', 'AgentPassword', 'Active', '', '', '代理官口号', null, '代理官口号', null, null);

-- ----------------------------
-- Table structure for lifecycle_event
-- ----------------------------
DROP TABLE IF EXISTS `lifecycle_event`;
CREATE TABLE `lifecycle_event` (
  `ID` int(15) NOT NULL AUTO_INCREMENT,
  `Role_Type` varchar(100) DEFAULT NULL,
  `Role_ID` int(15) DEFAULT NULL,
  `Fun` varchar(255) DEFAULT NULL,
  `Value_From` varchar(255) DEFAULT NULL,
  `Value_To` varchar(255) DEFAULT NULL,
  `Updated_Time` datetime DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
  `Updated_User` int(15) DEFAULT NULL,
  `Remark` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of lifecycle_event
-- ----------------------------

-- ----------------------------
-- Table structure for money
-- ----------------------------
DROP TABLE IF EXISTS `money`;
CREATE TABLE `money` (
  `Role_NO` int(10) DEFAULT NULL,
  `Fun` varchar(30) DEFAULT NULL,
  `Count_Money` double DEFAULT NULL,
  `balance` double DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of money
-- ----------------------------

-- ----------------------------
-- Table structure for money_log
-- ----------------------------
DROP TABLE IF EXISTS `money_log`;
CREATE TABLE `money_log` (
  `NO` varchar(40) DEFAULT NULL,
  `Type` varchar(40) DEFAULT NULL,
  `Value_From` varchar(100) DEFAULT NULL,
  `Value_To` varchar(100) DEFAULT NULL,
  `Amount` double DEFAULT NULL,
  `Status` varchar(60) DEFAULT NULL,
  `Create_Time` datetime DEFAULT NULL,
  `update_Time` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of money_log
-- ----------------------------

-- ----------------------------
-- Table structure for project
-- ----------------------------
DROP TABLE IF EXISTS `project`;
CREATE TABLE `project` (
  `Project_NO` int(15) NOT NULL AUTO_INCREMENT,
  `Project_Name` varchar(60) DEFAULT NULL,
  `Province` varchar(255) DEFAULT NULL,
  `City` varchar(255) DEFAULT NULL,
  `Money` double(11,0) DEFAULT NULL,
  `Money_Name` varchar(100) DEFAULT NULL,
  `Material` varchar(255) DEFAULT NULL,
  `Start_Time` datetime DEFAULT NULL,
  `End_Time` datetime DEFAULT NULL,
  `Entrants` int(11) DEFAULT NULL,
  `Entrants_Name` varchar(60) DEFAULT NULL,
  `Create_Time` datetime DEFAULT NULL,
  `Update_Time` datetime DEFAULT NULL,
  `Project_Require` varchar(255) DEFAULT NULL,
  `Status` varchar(60) DEFAULT NULL,
  `Book_Status` varchar(15) DEFAULT NULL,
  `Remark` varchar(255) DEFAULT NULL,
  `Readers` int(10) DEFAULT NULL,
  `Liked_Count` int(11) DEFAULT NULL,
  `Belong_NO` int(10) DEFAULT NULL,
  `Belong_Type` varchar(30) DEFAULT NULL,
  `Belong_Contact_NO` int(10) DEFAULT NULL,
  `Nature` varchar(255) DEFAULT NULL,
  `Type` varchar(255) DEFAULT NULL,
  `Urgent_Remark` varchar(255) DEFAULT NULL,
  `Money_Status` varchar(70) DEFAULT NULL,
  `Activity_Amount` int(15) DEFAULT NULL,
  PRIMARY KEY (`Project_NO`)
) ENGINE=InnoDB AUTO_INCREMENT=30000016 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of project
-- ----------------------------
INSERT INTO `project` VALUES ('30000000', '第十一届科技学术节', '', '潮州市', '900000024', null, '传单', '2016-08-23 00:00:00', '2016-08-09 00:00:00', '3', '300-499', '2016-08-20 20:29:06', '2016-08-20 20:29:06', '飞洒登封市大发生发射点', 'Open', 'Active', null, '0', '10', '400000000', 'Student', '10000001', '', '晚会类$%#体育类', '孙大发大水法', 'NoPayment', null);
INSERT INTO `project` VALUES ('30000001', '现货白银赞助书', '', '', '10000', '', '', '2016-08-02 00:00:00', '2016-08-02 00:00:00', '10', '100-299', '2016-08-20 23:53:25', '2016-08-24 15:24:08', 'ffdsafasfsdafsdf', 'Open', 'Active', '活动信息错误', '0', '0', '20000000', 'Company', '10000000', '', '', '3453453', 'NoPayment', null);
INSERT INTO `project` VALUES ('30000002', '广东省白银大赛赞助书', '', '汕头市', '10000', null, '传单', '2016-08-17 00:00:00', '2016-08-21 00:00:00', '2', '100-299', '2016-08-21 00:17:59', '2016-08-21 00:17:59', '', 'Approving', 'Pending', '真的是傻逼来着', '0', '0', '20000000', 'Company', '10000000', '', '表演类$%#晚会类', '534564', 'NoPayment', null);
INSERT INTO `project` VALUES ('30000003', '第十二届科技学术节', '', '潮州市', '100', null, '传单', '2016-08-23 00:00:00', '2016-08-09 00:00:00', '3', '300-499', '2016-08-20 20:29:06', '2016-08-20 20:29:06', '飞洒登封市大发生发射点', 'Approving', 'Active', null, '0', '10', '400000000', 'Student', '10000001', '', '晚会类$%#体育类', '孙大发大水法', 'NoPayment', null);
INSERT INTO `project` VALUES ('30000004', '毕马威中国留学赞助书', '', '湛江市$%#茂名市$%#珠海市', '5888888', '', '公司产品$%#传单', '2016-08-16 00:00:00', '2016-08-16 00:00:00', '20', '301-500', '2016-08-24 19:10:20', '2016-08-24 21:12:22', '这是一个很好的活动，我要你们好好搞！！！！！！！', 'Open', 'Pending', '', '0', '0', '20000000', 'Company', '10000000', '', '晚会类$%#体育类$%#讲座类', '黄烈全：18825195397', 'NoPayment', null);
INSERT INTO `project` VALUES ('30000005', '中国移动赞助书', '', '汕头市$%#湛江市$%#潮州市$%#茂名市$%#深圳市$%#韶关市$%#东莞市$%#江门市$%#佛山市$%#珠海市$%#中山市$%#河源市$%#汕尾市$%#阳江市$%#清远市$%#揭阳市', '8888', null, '传单$%#海报', '2016-08-01 00:00:00', '2016-09-10 00:00:00', '900000006', '501-1000', '2016-08-24 23:13:50', '2016-08-24 23:13:50', '中国移动牛逼，中国移动万岁', 'Draft', 'Pending', null, '0', '0', '20000000', 'Company', '10000000', '', '文艺类$%#表演类$%#晚会类$%#体育类$%#讲座类', '黄烈全：18825195397', 'NoPayment', null);
INSERT INTO `project` VALUES ('30000006', '唱出宇宙赞助书', '', '汕头市$%#江门市$%#佛山市$%#清远市$%#揭阳市', '55555', null, '公司产品$%#传单$%#海报', '2016-08-10 00:00:00', '2016-09-10 00:00:00', '900000004', '101-300', '2016-08-24 23:18:24', '2016-08-24 23:18:24', '好好搞，不会亏待你们', 'Approving', 'Pending', null, '0', '0', '20000000', 'Company', '10000000', '', '表演类$%#晚会类$%#体育类$%#讲座类', '杨志兵：18825195397', 'NoPayment', null);
INSERT INTO `project` VALUES ('30000007', '我爱你中国赞助书', '', '广州市$%#潮州市$%#茂名市$%#韶关市$%#梅州市$%#惠州市$%#东莞市$%#珠海市$%#阳江市', '666', null, '公司产品$%#传单$%#海报', '2016-08-17 00:00:00', '2016-08-16 00:00:00', '900000003', '0-100', '2016-08-24 23:21:23', '2016-08-24 23:21:23', '我爱你中国赞助书方案要求', 'Cancel', 'Pending', null, '0', '0', '20000000', 'Company', '10000000', '', '表演类$%#晚会类', '李晓波：1882254552', 'NoPayment', null);
INSERT INTO `project` VALUES ('30000008', '黄烈全赞助书', '', '湛江市$%#潮州市$%#惠州市$%#东莞市$%#江门市$%#肇庆市$%#清远市', '665656', null, '', '2016-08-09 00:00:00', '2016-08-10 00:00:00', '900000007', '1001-1500', '2016-08-24 23:22:42', '2016-08-24 23:22:42', '都是好的要求', 'Open', 'Pending', null, '0', '0', '20000000', 'Company', '10000000', '', '表演类$%#晚会类$%#体育类', '全都是泡沫', 'NoPayment', null);
INSERT INTO `project` VALUES ('30000009', '我真TM的帅啊', '', '湛江市$%#潮州市$%#惠州市$%#东莞市$%#江门市$%#肇庆市$%#清远市', '665656', null, '', '2016-08-09 00:00:00', '2016-08-10 00:00:00', '900000007', '1001-1500', '2016-08-24 23:22:42', '2016-08-24 23:22:42', '都是好的要求', 'Rejected', 'Pending', '滚', '0', '0', '20000000', 'Company', '10000000', '', '表演类$%#晚会类$%#体育类', '全都是泡沫', 'NoPayment', null);
INSERT INTO `project` VALUES ('30000010', '老子不服，就是拿来测试的', '', '湛江市$%#潮州市$%#惠州市$%#东莞市$%#江门市$%#肇庆市$%#清远市', '665656', null, '', '2016-08-09 00:00:00', '2016-08-10 00:00:00', '900000007', '1001-1500', '2016-08-02 23:22:42', '2016-08-24 23:22:42', '都是好的要求', 'Rejected', 'Pending', '傻逼', '0', '0', '20000000', 'Company', '10000000', '', '表演类$%#晚会类$%#体育类', '全都是泡沫', 'NoPayment', null);
INSERT INTO `project` VALUES ('30000011', '第五届奥运', '', '潮州市', '900000011', null, '传单', '2016-08-23 00:00:00', '2016-08-09 00:00:00', '900000007', '1001-1500', '2016-09-09 20:29:06', '2016-08-20 20:29:06', '飞洒登封市大发生发射点', 'Open', 'Active', null, '0', '54', '400000001', 'Student', '10000001', '', '晚会', '李晓波：1882254552', 'NoPayment', null);
INSERT INTO `project` VALUES ('30000012', '科技文化节之文豆杯', '', '潮州市', '900000012', null, '传单', '2016-08-23 00:00:00', '2016-08-09 00:00:00', '900000007', '1001-1500', '2016-08-06 20:29:06', '2016-08-20 20:29:06', '飞洒登封市大发生发射点', 'Open', 'Active', null, '0', '100', '400000002', 'Student', '10000001', '', '晚会', '李晓波：1882254552', 'NoPayment', null);
INSERT INTO `project` VALUES ('30000013', '宿舍文化节', '', '潮州市', '900000013', null, '传单', '2016-08-23 00:00:00', '2016-08-09 00:00:00', '900000007', '1001-1500', '2016-08-03 20:29:06', '2016-08-20 20:29:06', '飞洒登封市大发生发射点', 'Open', 'Active', null, '0', '100', '400000003', 'Student', '10000001', '', '晚会', '李晓波：1882254552', 'NoPayment', null);
INSERT INTO `project` VALUES ('30000014', '计算机制霸会', '', '潮州市', '900000014', null, '传单', '2016-08-23 00:00:00', '2016-08-09 00:00:00', '900000007', '1001-1500', '2016-09-23 20:29:06', '2016-08-20 20:29:06', '飞洒登封市大发生发射点', 'Open', 'Active', null, '0', '100', '400000004', 'Student', '10000001', '', '晚会', '李晓波：1882254552', 'NoPayment', null);
INSERT INTO `project` VALUES ('30000015', '华软晚会', '', '潮州市', '900000015', null, '传单', '2016-08-23 00:00:00', '2016-08-09 00:00:00', '900000007', '1001-1500', '2016-08-09 20:29:06', '2016-08-20 20:29:06', '飞洒登封市大发生发射点', 'Open', 'Active', null, '0', '100', '400000005', 'Student', '10000001', '', '晚会', '李晓波：1882254552', 'NoPayment', null);

-- ----------------------------
-- Table structure for project_extend
-- ----------------------------
DROP TABLE IF EXISTS `project_extend`;
CREATE TABLE `project_extend` (
  `Project_NO` int(15) DEFAULT NULL,
  `Fun` varchar(100) DEFAULT NULL,
  `Code` int(20) DEFAULT NULL,
  `Description` varchar(255) DEFAULT NULL,
  `Value` varchar(200) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of project_extend
-- ----------------------------
INSERT INTO `project_extend` VALUES ('30000000', 'Type', '900000044', null, '晚会类');
INSERT INTO `project_extend` VALUES ('30000000', 'Type', '21', null, '体育类');
INSERT INTO `project_extend` VALUES ('30000000', 'Material', '2', null, '传单');
INSERT INTO `project_extend` VALUES ('30000000', 'City', '4', null, '潮州市');
INSERT INTO `project_extend` VALUES ('30000001', 'Type', '2', null, '表演类');
INSERT INTO `project_extend` VALUES ('30000001', 'Type', '4', null, '体育类');
INSERT INTO `project_extend` VALUES ('30000001', 'Material', '2', null, '传单');
INSERT INTO `project_extend` VALUES ('30000001', 'Material', '3', null, '海报');
INSERT INTO `project_extend` VALUES ('30000001', 'City', '3', null, '湛江市');
INSERT INTO `project_extend` VALUES ('30000001', 'City', '11', null, '江门市');
INSERT INTO `project_extend` VALUES ('30000002', 'Type', '2', null, '表演类');
INSERT INTO `project_extend` VALUES ('30000002', 'Type', '3', null, '晚会类');
INSERT INTO `project_extend` VALUES ('30000002', 'Material', '2', null, '传单');
INSERT INTO `project_extend` VALUES ('30000002', 'City', '2', null, '汕头市');
INSERT INTO `project_extend` VALUES ('30000004', 'Type', '900000043', null, '晚会类');
INSERT INTO `project_extend` VALUES ('30000004', 'Type', '900000044', null, '体育类');
INSERT INTO `project_extend` VALUES ('30000004', 'Type', '900000045', null, '讲座类');
INSERT INTO `project_extend` VALUES ('30000004', 'Material', '1', null, '公司产品');
INSERT INTO `project_extend` VALUES ('30000004', 'Material', '2', null, '传单');
INSERT INTO `project_extend` VALUES ('30000004', 'City', '3', null, '湛江市');
INSERT INTO `project_extend` VALUES ('30000004', 'City', '5', null, '茂名市');
INSERT INTO `project_extend` VALUES ('30000004', 'City', '14', null, '珠海市');
INSERT INTO `project_extend` VALUES ('30000005', 'Type', '900000041', null, '文艺类');
INSERT INTO `project_extend` VALUES ('30000005', 'Type', '900000042', null, '表演类');
INSERT INTO `project_extend` VALUES ('30000005', 'Type', '900000043', null, '晚会类');
INSERT INTO `project_extend` VALUES ('30000005', 'Type', '900000044', null, '体育类');
INSERT INTO `project_extend` VALUES ('30000005', 'Type', '900000045', null, '讲座类');
INSERT INTO `project_extend` VALUES ('30000005', 'Material', '2', null, '传单');
INSERT INTO `project_extend` VALUES ('30000005', 'Material', '3', null, '海报');
INSERT INTO `project_extend` VALUES ('30000005', 'City', '300001', null, '汕头市');
INSERT INTO `project_extend` VALUES ('30000005', 'City', '300002', null, '湛江市');
INSERT INTO `project_extend` VALUES ('30000005', 'City', '300003', null, '潮州市');
INSERT INTO `project_extend` VALUES ('30000005', 'City', '300004', null, '茂名市');
INSERT INTO `project_extend` VALUES ('30000005', 'City', '300005', null, '深圳市');
INSERT INTO `project_extend` VALUES ('30000005', 'City', '300006', null, '韶关市');
INSERT INTO `project_extend` VALUES ('30000005', 'City', '300009', null, '东莞市');
INSERT INTO `project_extend` VALUES ('30000005', 'City', '300010', null, '江门市');
INSERT INTO `project_extend` VALUES ('30000005', 'City', '300011', null, '佛山市');
INSERT INTO `project_extend` VALUES ('30000005', 'City', '300013', null, '珠海市');
INSERT INTO `project_extend` VALUES ('30000005', 'City', '300014', null, '中山市');
INSERT INTO `project_extend` VALUES ('30000005', 'City', '300015', null, '河源市');
INSERT INTO `project_extend` VALUES ('30000005', 'City', '300016', null, '汕尾市');
INSERT INTO `project_extend` VALUES ('30000005', 'City', '300017', null, '阳江市');
INSERT INTO `project_extend` VALUES ('30000005', 'City', '300018', null, '清远市');
INSERT INTO `project_extend` VALUES ('30000005', 'City', '300019', null, '揭阳市');
INSERT INTO `project_extend` VALUES ('30000006', 'Type', '900000042', null, '表演类');
INSERT INTO `project_extend` VALUES ('30000006', 'Type', '900000043', null, '晚会类');
INSERT INTO `project_extend` VALUES ('30000006', 'Type', '900000044', null, '体育类');
INSERT INTO `project_extend` VALUES ('30000006', 'Type', '900000045', null, '讲座类');
INSERT INTO `project_extend` VALUES ('30000006', 'Material', '1', null, '公司产品');
INSERT INTO `project_extend` VALUES ('30000006', 'Material', '2', null, '传单');
INSERT INTO `project_extend` VALUES ('30000006', 'Material', '3', null, '海报');
INSERT INTO `project_extend` VALUES ('30000006', 'City', '300001', null, '汕头市');
INSERT INTO `project_extend` VALUES ('30000006', 'City', '300010', null, '江门市');
INSERT INTO `project_extend` VALUES ('30000006', 'City', '300011', null, '佛山市');
INSERT INTO `project_extend` VALUES ('30000006', 'City', '300018', null, '清远市');
INSERT INTO `project_extend` VALUES ('30000006', 'City', '300019', null, '揭阳市');
INSERT INTO `project_extend` VALUES ('30000007', 'Type', '900000042', null, '表演类');
INSERT INTO `project_extend` VALUES ('30000007', 'Type', '900000043', null, '晚会类');
INSERT INTO `project_extend` VALUES ('30000007', 'Material', '1', null, '公司产品');
INSERT INTO `project_extend` VALUES ('30000007', 'Material', '2', null, '传单');
INSERT INTO `project_extend` VALUES ('30000007', 'Material', '3', null, '海报');
INSERT INTO `project_extend` VALUES ('30000007', 'City', '300000', null, '广州市');
INSERT INTO `project_extend` VALUES ('30000007', 'City', '300003', null, '潮州市');
INSERT INTO `project_extend` VALUES ('30000007', 'City', '300004', null, '茂名市');
INSERT INTO `project_extend` VALUES ('30000007', 'City', '300006', null, '韶关市');
INSERT INTO `project_extend` VALUES ('30000007', 'City', '300007', null, '梅州市');
INSERT INTO `project_extend` VALUES ('30000007', 'City', '300008', null, '惠州市');
INSERT INTO `project_extend` VALUES ('30000007', 'City', '300009', null, '东莞市');
INSERT INTO `project_extend` VALUES ('30000007', 'City', '300013', null, '珠海市');
INSERT INTO `project_extend` VALUES ('30000007', 'City', '300017', null, '阳江市');
INSERT INTO `project_extend` VALUES ('30000008', 'Type', '900000042', null, '表演类');
INSERT INTO `project_extend` VALUES ('30000008', 'Type', '900000043', null, '晚会类');
INSERT INTO `project_extend` VALUES ('30000008', 'Type', '900000044', null, '体育类');
INSERT INTO `project_extend` VALUES ('30000008', 'City', '300002', null, '湛江市');
INSERT INTO `project_extend` VALUES ('30000008', 'City', '300003', null, '潮州市');
INSERT INTO `project_extend` VALUES ('30000008', 'City', '300008', null, '惠州市');
INSERT INTO `project_extend` VALUES ('30000008', 'City', '300009', null, '东莞市');
INSERT INTO `project_extend` VALUES ('30000008', 'City', '300010', null, '江门市');
INSERT INTO `project_extend` VALUES ('30000008', 'City', '300012', null, '肇庆市');
INSERT INTO `project_extend` VALUES ('30000008', 'City', '300018', null, '清远市');
INSERT INTO `project_extend` VALUES ('30000012', 'Type', '900000042', null, '表演类');
INSERT INTO `project_extend` VALUES ('30000011', 'Type', '900000043', null, '晚会类');
INSERT INTO `project_extend` VALUES ('30000013', 'Type', '900000044', null, '体育类');
INSERT INTO `project_extend` VALUES ('30000014', 'Type', '900000045', null, '讲座类');
INSERT INTO `project_extend` VALUES ('30000015', 'Type', '900000046', null, '比赛类');

-- ----------------------------
-- Table structure for project_field
-- ----------------------------
DROP TABLE IF EXISTS `project_field`;
CREATE TABLE `project_field` (
  `Project_NO` int(15) DEFAULT NULL,
  `Fun` varchar(60) DEFAULT NULL,
  `Status` varchar(60) DEFAULT NULL,
  `From_User` varchar(15) DEFAULT NULL,
  `To_User` varchar(15) DEFAULT NULL,
  `Field_Value` varchar(255) DEFAULT NULL,
  `Create_Time` datetime DEFAULT NULL,
  KEY `FKProject_Fi868447` (`Project_NO`),
  CONSTRAINT `FKProject_Fi868447` FOREIGN KEY (`Project_NO`) REFERENCES `project` (`Project_NO`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of project_field
-- ----------------------------
INSERT INTO `project_field` VALUES ('30000001', 'FirstFeedback', 'Active', null, '25', '2244', '2016-08-22 11:37:53');
INSERT INTO `project_field` VALUES ('30000000', 'FirstFeedback', 'Active', null, '25', 'hhhhh', '2016-08-22 11:37:53');

-- ----------------------------
-- Table structure for project_items
-- ----------------------------
DROP TABLE IF EXISTS `project_items`;
CREATE TABLE `project_items` (
  `Project_NO` int(15) DEFAULT NULL,
  `Intention_Role` varchar(30) DEFAULT NULL,
  `Intention_Role_NO` varchar(15) DEFAULT NULL,
  `Intention_Contact_NO` varchar(15) DEFAULT NULL,
  `Status` varchar(15) DEFAULT NULL,
  `Create_Time` datetime DEFAULT NULL,
  `Update_Time` datetime DEFAULT NULL,
  `Remarks` varchar(255) DEFAULT NULL,
  `Is_Student_Confirm` int(1) DEFAULT NULL,
  `Student_Book_Remark` varchar(400) DEFAULT NULL,
  `Is_Company_Confirm` int(1) DEFAULT NULL,
  `Company_Book_Remark` varchar(400) DEFAULT NULL,
  `Urgent_Remark` varchar(400) DEFAULT NULL,
  `ContractNO` varchar(40) DEFAULT NULL,
  `Have_Offline_Team` int(1) DEFAULT NULL,
  `Have_Invoice` int(1) DEFAULT NULL,
  `Project_NO_Self` int(15) DEFAULT NULL,
  `Project_Self_Status` varchar(100) DEFAULT NULL,
  `Intention_Name` varchar(255) DEFAULT NULL,
  `Choose_Type` varchar(100) DEFAULT NULL,
  `Money_Status` varchar(100) DEFAULT NULL,
  `Project_Item_NO` int(15) NOT NULL AUTO_INCREMENT,
  `Submit_Time` datetime DEFAULT NULL,
  PRIMARY KEY (`Project_Item_NO`),
  KEY `FKProject_It966760` (`Project_NO`),
  CONSTRAINT `FKProject_It966760` FOREIGN KEY (`Project_NO`) REFERENCES `project` (`Project_NO`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of project_items
-- ----------------------------
INSERT INTO `project_items` VALUES ('30000001', 'Student', '400000002', '10000001', 'Submit', '2016-08-21 23:07:10', '2016-08-21 23:07:10', '', '0', '', '0', '', '', '', '0', '0', '30000012', null, '', 'SystemChoose', 'NoPayment', '1', '2016-08-21 23:07:10');
INSERT INTO `project_items` VALUES ('30000000', 'Company', '20000000', '10000000', 'Draft', '2016-08-21 23:07:10', '2016-08-21 23:07:10', '', '0', '', '0', '', '', '', '0', '0', '30000001', '', '', 'CompanyChoose', 'NoPayment', '2', '2016-08-26 00:15:23');
INSERT INTO `project_items` VALUES ('30000004', 'Student', '400000000', '10000001', 'Rejected', '2016-08-24 21:12:31', '2016-08-24 21:12:31', '', '0', '', '0', '', '', '', '0', '0', '30000000', null, '', 'StudentChoose', 'NoPayment', '7', '2016-08-23 00:15:20');
INSERT INTO `project_items` VALUES ('30000015', 'Company', '20000000', '10000000', 'Submit', '2016-08-21 23:07:10', '2016-08-21 23:07:10', '', '0', '', '0', '', '', '', '0', '0', '30000006', '', '', 'CompanyChoose', 'NoPayment', '8', '2016-08-24 00:15:17');
INSERT INTO `project_items` VALUES ('30000006', 'Student', '400000003', '10000001', 'Approving', '2016-08-24 21:12:31', '2016-08-24 21:12:31', '', '0', '', '0', '', '', '', '0', '0', '30000013', null, '', 'StudentChoose', 'NoPayment', '9', '2016-08-23 00:15:20');
INSERT INTO `project_items` VALUES ('30000003', 'Company', '400000005', '10000001', 'Approving', '2016-08-24 21:12:31', '2016-08-24 21:12:31', '', '0', '', '0', '', '', '', '0', '0', '30000011', null, '', 'CompanyChoose', 'NoPayment', '10', '2016-08-23 00:15:20');

-- ----------------------------
-- Table structure for school
-- ----------------------------
DROP TABLE IF EXISTS `school`;
CREATE TABLE `school` (
  `School_NO` int(10) NOT NULL AUTO_INCREMENT,
  `School_Name` varchar(60) DEFAULT NULL,
  `Student_SIze` int(11) DEFAULT NULL,
  `Province_Name` varchar(25) DEFAULT NULL,
  `City_Name` varchar(25) DEFAULT NULL,
  `Address` varchar(255) DEFAULT NULL,
  `City_NO` int(15) DEFAULT NULL,
  `Province_NO` int(15) DEFAULT NULL,
  PRIMARY KEY (`School_NO`)
) ENGINE=InnoDB AUTO_INCREMENT=500148 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of school
-- ----------------------------
INSERT INTO `school` VALUES ('101', '', null, null, null, null, null, null);
INSERT INTO `school` VALUES ('500001', '东莞理工学院', null, null, '东莞市', null, '300009', null);
INSERT INTO `school` VALUES ('500002', '广东科技学院', null, null, '东莞市', null, '300009', null);
INSERT INTO `school` VALUES ('500003', '东莞理工学院城市学院', null, null, '东莞市', null, '300009', null);
INSERT INTO `school` VALUES ('500004', '东莞职业技术学院', null, null, '东莞市', null, '300009', null);
INSERT INTO `school` VALUES ('500005', '广东亚视演艺职业学院', null, null, '东莞市', null, '300009', null);
INSERT INTO `school` VALUES ('500006', '广东创新科技职业学院', null, null, '东莞市', null, '300009', null);
INSERT INTO `school` VALUES ('500007', '广东酒店管理职业技术学院', null, null, '东莞市', null, '300009', null);
INSERT INTO `school` VALUES ('500008', '电子科技大学中山学院', null, null, '中山市', null, '300014', null);
INSERT INTO `school` VALUES ('500009', '中山火炬职业技术学院', null, null, '中山市', null, '300014', null);
INSERT INTO `school` VALUES ('500010', '中山职业技术学院', null, null, '中山市', null, '300014', null);
INSERT INTO `school` VALUES ('500011', '罗定职业技术学院', null, null, '云浮市', null, '300020', null);
INSERT INTO `school` VALUES ('500012', '佛山科学技术学院', null, null, '佛山市', null, '300011', null);
INSERT INTO `school` VALUES ('500013', '广东东软学院', null, null, '佛山市', null, '300011', null);
INSERT INTO `school` VALUES ('500014', '广东职业技术学院', null, null, '佛山市', null, '300011', null);
INSERT INTO `school` VALUES ('500015', '广东科贸职业学院', null, null, '佛山市', null, '300011', null);
INSERT INTO `school` VALUES ('500016', '佛山职业技术学院', null, null, '佛山市', null, '300011', null);
INSERT INTO `school` VALUES ('500017', '顺德职业技术学院', null, null, '佛山市', null, '300011', null);
INSERT INTO `school` VALUES ('500018', '中山大学', null, null, '广州市', null, '300000', null);
INSERT INTO `school` VALUES ('500019', '华南理工大学', null, null, '广州市', null, '300000', null);
INSERT INTO `school` VALUES ('500020', '暨南大学', null, null, '广州市', null, '300000', null);
INSERT INTO `school` VALUES ('500021', '华南农业大学', null, null, '广州市', null, '300000', null);
INSERT INTO `school` VALUES ('500022', '南方医科大学', null, null, '广州市', null, '300000', null);
INSERT INTO `school` VALUES ('500023', '广州中医药大学', null, null, '广州市', null, '300000', null);
INSERT INTO `school` VALUES ('500024', '华南师范大学', null, null, '广州市', null, '300000', null);
INSERT INTO `school` VALUES ('500025', '广东工业大学', null, null, '广州市', null, '300000', null);
INSERT INTO `school` VALUES ('500026', '广东外语外贸大学', null, null, '广州市', null, '300000', null);
INSERT INTO `school` VALUES ('500027', '广东财经大学', null, null, '广州市', null, '300000', null);
INSERT INTO `school` VALUES ('500028', '仲恺农业工程学院', null, null, '广州市', null, '300000', null);
INSERT INTO `school` VALUES ('500029', '广东药科大学', null, null, '广州市', null, '300000', null);
INSERT INTO `school` VALUES ('500030', '星海音乐学院', null, null, '广州市', null, '300000', null);
INSERT INTO `school` VALUES ('500031', '广州美术学院', null, null, '广州市', null, '300000', null);
INSERT INTO `school` VALUES ('500032', '广州体育学院', null, null, '广州市', null, '300000', null);
INSERT INTO `school` VALUES ('500033', '广东技术师范学院', null, null, '广州市', null, '300000', null);
INSERT INTO `school` VALUES ('500034', '广东金融学院', null, null, '广州市', null, '300000', null);
INSERT INTO `school` VALUES ('500035', '广东警官学院', null, null, '广州市', null, '300000', null);
INSERT INTO `school` VALUES ('500036', '广东第二师范学院', null, null, '广州市', null, '300000', null);
INSERT INTO `school` VALUES ('500037', '广州航海学院', null, null, '广州市', null, '300000', null);
INSERT INTO `school` VALUES ('500038', '广州大学', null, null, '广州市', null, '300000', null);
INSERT INTO `school` VALUES ('500039', '广州医科大学', null, null, '广州市', null, '300000', null);
INSERT INTO `school` VALUES ('500040', '广东培正学院', null, null, '广州市', null, '300000', null);
INSERT INTO `school` VALUES ('500041', '广东白云学院', null, null, '广州市', null, '300000', null);
INSERT INTO `school` VALUES ('500042', '广州商学院', null, null, '广州市', null, '300000', null);
INSERT INTO `school` VALUES ('500043', '广州工商学院', null, null, '广州市', null, '300000', null);
INSERT INTO `school` VALUES ('500044', '广东工业大学华立学院 ', null, null, '广州市', null, '300000', null);
INSERT INTO `school` VALUES ('500045', '广州大学松田学院', null, null, '广州市', null, '300000', null);
INSERT INTO `school` VALUES ('500046', '中山大学新华学院', null, null, '广州市', null, '300000', null);
INSERT INTO `school` VALUES ('500047', '中山大学南方学院', null, null, '广州市', null, '300000', null);
INSERT INTO `school` VALUES ('500048', '华南理工大学广州学院', null, null, '广州市', null, '300000', null);
INSERT INTO `school` VALUES ('500049', '华南农业大学珠江学院', null, null, '广州市', null, '300000', null);
INSERT INTO `school` VALUES ('500050', '广东外语外贸大学南国商学院', null, null, '广州市', null, '300000', null);
INSERT INTO `school` VALUES ('500051', '广东财经大学华商学院', null, null, '广州市', null, '300000', null);
INSERT INTO `school` VALUES ('500052', '广东技术师范学院天河学院', null, null, '广州市', null, '300000', null);
INSERT INTO `school` VALUES ('500053', '广州大学华软软件学院', null, null, '广州市', null, '300000', null);
INSERT INTO `school` VALUES ('500054', '广州民航职业技术学院', null, null, '广州市', null, '300000', null);
INSERT INTO `school` VALUES ('500055', '广东轻工职业技术学院', null, null, '广州市', null, '300000', null);
INSERT INTO `school` VALUES ('500056', '广东省外语艺术职业学院', null, null, '广州市', null, '300000', null);
INSERT INTO `school` VALUES ('500057', '广东机电职业技术学院', null, null, '广州市', null, '300000', null);
INSERT INTO `school` VALUES ('500058', '广东工贸职业技术学院', null, null, '广州市', null, '300000', null);
INSERT INTO `school` VALUES ('500059', '广东建设职业技术学院', null, null, '广州市', null, '300000', null);
INSERT INTO `school` VALUES ('500060', '广东理工职业学院', null, null, '广州市', null, '300000', null);
INSERT INTO `school` VALUES ('500061', '广东科学技术职业学院', null, null, '广州市', null, '300000', null);
INSERT INTO `school` VALUES ('500062', '广东交通职业技术学院', null, null, '广州市', null, '300000', null);
INSERT INTO `school` VALUES ('500063', '广东水利电力职业技术学院', null, null, '广州市', null, '300000', null);
INSERT INTO `school` VALUES ('500064', '广东司法警官职业学院', null, null, '广州市', null, '300000', null);
INSERT INTO `school` VALUES ('500065', '广东行政职业学院', null, null, '广州市', null, '300000', null);
INSERT INTO `school` VALUES ('500066', '广东体育职业技术学院', null, null, '广州市', null, '300000', null);
INSERT INTO `school` VALUES ('500067', '广东文艺职业学院', null, null, '广州市', null, '300000', null);
INSERT INTO `school` VALUES ('500068', '广东食品药品职业学院', null, null, '广州市', null, '300000', null);
INSERT INTO `school` VALUES ('500069', '广东女子职业技术学院', null, null, '广州市', null, '300000', null);
INSERT INTO `school` VALUES ('500070', '广东农工商职业技术学院', null, null, '广州市', null, '300000', null);
INSERT INTO `school` VALUES ('500071', '广东邮电职业技术学院', null, null, '广州市', null, '300000', null);
INSERT INTO `school` VALUES ('500072', '广东工程职业技术学院', null, null, '广州市', null, '300000', null);
INSERT INTO `school` VALUES ('500073', '广东环境保护工程职业学院', null, null, '广州市', null, '300000', null);
INSERT INTO `school` VALUES ('500074', '广东青年职业学院', null, null, '广州市', null, '300000', null);
INSERT INTO `school` VALUES ('500075', '广东舞蹈戏剧职业学院', null, null, '广州市', null, '300000', null);
INSERT INTO `school` VALUES ('500076', '广东生态工程职业学院', null, null, '广州市', null, '300000', null);
INSERT INTO `school` VALUES ('500077', '广州番禺职业技术学院', null, null, '广州市', null, '300000', null);
INSERT INTO `school` VALUES ('500078', '广州体育职业技术学院', null, null, '广州市', null, '300000', null);
INSERT INTO `school` VALUES ('500079', '广州工程技术职业学院', null, null, '广州市', null, '300000', null);
INSERT INTO `school` VALUES ('500080', '广州铁路职业技术学院', null, null, '广州市', null, '300000', null);
INSERT INTO `school` VALUES ('500081', '广州城市职业学院', null, null, '广州市', null, '300000', null);
INSERT INTO `school` VALUES ('500082', '广州科技贸易职业学院', null, null, '广州市', null, '300000', null);
INSERT INTO `school` VALUES ('500083', '民办南华工商学院', null, null, '广州市', null, '300000', null);
INSERT INTO `school` VALUES ('500084', '私立华联学院', null, null, '广州市', null, '300000', null);
INSERT INTO `school` VALUES ('500085', '广东岭南职业技术学院', null, null, '广州市', null, '300000', null);
INSERT INTO `school` VALUES ('500086', '广州康大职业技术学院', null, null, '广州市', null, '300000', null);
INSERT INTO `school` VALUES ('500087', '广州涉外经济职业技术学院', null, null, '广州市', null, '300000', null);
INSERT INTO `school` VALUES ('500088', '广州南洋理工职业学院', null, null, '广州市', null, '300000', null);
INSERT INTO `school` VALUES ('500089', '广州科技职业技术学院', null, null, '广州市', null, '300000', null);
INSERT INTO `school` VALUES ('500090', '广州华南商贸职业学院', null, null, '广州市', null, '300000', null);
INSERT INTO `school` VALUES ('500091', '广州华立科技职业学院', null, null, '广州市', null, '300000', null);
INSERT INTO `school` VALUES ('500092', '广州现代信息工程职业技术学院', null, null, '广州市', null, '300000', null);
INSERT INTO `school` VALUES ('500093', '广州珠江职业技术学院', null, null, '广州市', null, '300000', null);
INSERT INTO `school` VALUES ('500094', '广州松田职业学院', null, null, '广州市', null, '300000', null);
INSERT INTO `school` VALUES ('500095', '广州城建职业学院', null, null, '广州市', null, '300000', null);
INSERT INTO `school` VALUES ('500096', '广州华商职业学院', null, null, '广州市', null, '300000', null);
INSERT INTO `school` VALUES ('500097', '广州华夏职业学院', null, null, '广州市', null, '300000', null);
INSERT INTO `school` VALUES ('500098', '广州东华职业学院', null, null, '广州市', null, '300000', null);
INSERT INTO `school` VALUES ('500099', '公安边防部队高等专科学校', null, null, '广州市', null, '300000', null);
INSERT INTO `school` VALUES ('500100', '广州卫生职业技术学院', null, null, '广州市', null, '300000', null);
INSERT INTO `school` VALUES ('500101', '惠州学院', null, null, '惠州市', null, '300008', null);
INSERT INTO `school` VALUES ('500102', '惠州卫生职业技术学院', null, null, '惠州市', null, '300008', null);
INSERT INTO `school` VALUES ('500103', '惠州城市职业学院', null, null, '惠州市', null, '300008', null);
INSERT INTO `school` VALUES ('500104', '惠州经济职业技术学院', null, null, '惠州市', null, '300008', null);
INSERT INTO `school` VALUES ('500105', '揭阳职业技术学院', null, null, '揭阳市', null, '300019', null);
INSERT INTO `school` VALUES ('500106', '潮汕职业技术学院', null, null, '揭阳市', null, '300019', null);
INSERT INTO `school` VALUES ('500107', '嘉应学院', null, null, '梅州市', null, '300007', null);
INSERT INTO `school` VALUES ('500108', '汕头大学', null, null, '汕头市', null, '300001', null);
INSERT INTO `school` VALUES ('500109', '汕头职业技术学院', null, null, '汕头市', null, '300001', null);
INSERT INTO `school` VALUES ('500110', '汕尾职业技术学院', null, null, '汕尾市', null, '300016', null);
INSERT INTO `school` VALUES ('500111', '五邑大学', null, null, '江门市', null, '300010', null);
INSERT INTO `school` VALUES ('500112', '江门职业技术学院', null, null, '江门市', null, '300010', null);
INSERT INTO `school` VALUES ('500113', '广东南方职业学院', null, null, '江门市', null, '300010', null);
INSERT INTO `school` VALUES ('500114', '河源职业技术学院', null, null, '河源市', null, '300015', null);
INSERT INTO `school` VALUES ('500115', '深圳大学', null, null, '深圳市', null, '300005', null);
INSERT INTO `school` VALUES ('500116', '南方科技大学', null, null, '深圳市', null, '300005', null);
INSERT INTO `school` VALUES ('500117', '香港中文大学（深圳）', null, null, '深圳市', null, '300005', null);
INSERT INTO `school` VALUES ('500118', '深圳职业技术学院', null, null, '深圳市', null, '300005', null);
INSERT INTO `school` VALUES ('500119', '深圳信息职业技术学院', null, null, '深圳市', null, '300005', null);
INSERT INTO `school` VALUES ('500120', '广东新安职业技术学院', null, null, '深圳市', null, '300005', null);
INSERT INTO `school` VALUES ('500121', '清远职业技术学院', null, null, '清远市', null, '300018', null);
INSERT INTO `school` VALUES ('500122', '广东碧桂园职业学院', null, null, '清远市', null, '300018', null);
INSERT INTO `school` VALUES ('500123', '广东医科大学', null, null, '湛江市', null, '300002', null);
INSERT INTO `school` VALUES ('500124', '广东海洋大学', null, null, '湛江市', null, '300002', null);
INSERT INTO `school` VALUES ('500125', '岭南师范学院', null, null, '湛江市', null, '300002', null);
INSERT INTO `school` VALUES ('500126', '广东海洋大学寸金学院', null, null, '湛江市', null, '300002', null);
INSERT INTO `school` VALUES ('500127', '广东文理职业学院', null, null, '湛江市', null, '300002', null);
INSERT INTO `school` VALUES ('500128', '湛江幼儿师范专科学校', null, null, '湛江市', null, '300002', null);
INSERT INTO `school` VALUES ('500129', '韩山师范学院', null, null, '潮州市', null, '300003', null);
INSERT INTO `school` VALUES ('500130', '北京师范大学－香港浸会大学联合国际学院', null, null, '珠海市', null, '300013', null);
INSERT INTO `school` VALUES ('500131', '北京师范大学珠海分校', null, null, '珠海市', null, '300013', null);
INSERT INTO `school` VALUES ('500132', '北京理工大学珠海学院', null, null, '珠海市', null, '300013', null);
INSERT INTO `school` VALUES ('500133', '吉林大学珠海学院', null, null, '珠海市', null, '300013', null);
INSERT INTO `school` VALUES ('500134', '珠海城市职业技术学院', null, null, '珠海市', null, '300013', null);
INSERT INTO `school` VALUES ('500135', '珠海艺术职业学院', null, null, '珠海市', null, '300013', null);
INSERT INTO `school` VALUES ('500136', '肇庆学院', null, null, '肇庆市', null, '300012', null);
INSERT INTO `school` VALUES ('500137', '广东理工学院', null, null, '肇庆市', null, '300012', null);
INSERT INTO `school` VALUES ('500138', '肇庆医学高等专科学校', null, null, '肇庆市', null, '300012', null);
INSERT INTO `school` VALUES ('500139', '广东工商职业学院', null, null, '肇庆市', null, '300012', null);
INSERT INTO `school` VALUES ('500140', '广东信息工程职业学院', null, null, '肇庆市', null, '300012', null);
INSERT INTO `school` VALUES ('500141', '广东石油化工学院', null, null, '茂名市', null, '300004', null);
INSERT INTO `school` VALUES ('500142', '茂名职业技术学院', null, null, '茂名市', null, '300004', null);
INSERT INTO `school` VALUES ('500143', '广东茂名健康职业学院', null, null, '茂名市', null, '300004', null);
INSERT INTO `school` VALUES ('500144', '广东茂名幼儿师范专科学校', null, null, '茂名市', null, '300004', null);
INSERT INTO `school` VALUES ('500145', '阳江职业技术学院', null, null, '阳江市', null, '300017', null);
INSERT INTO `school` VALUES ('500146', '韶关学院', null, null, '韶关市', null, '300006', null);
INSERT INTO `school` VALUES ('500147', '广东松山职业技术学院', null, null, '韶关市', null, '300006', null);

-- ----------------------------
-- Table structure for school_student_association
-- ----------------------------
DROP TABLE IF EXISTS `school_student_association`;
CREATE TABLE `school_student_association` (
  `Role_From` int(15) DEFAULT NULL,
  `Fun` varchar(100) DEFAULT NULL,
  `Role_To` int(15) DEFAULT NULL,
  `Name_From` varchar(200) DEFAULT NULL,
  `Status` varchar(100) DEFAULT NULL,
  `Name_To` varchar(100) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of school_student_association
-- ----------------------------

-- ----------------------------
-- Table structure for sheet2
-- ----------------------------
DROP TABLE IF EXISTS `sheet2`;
CREATE TABLE `sheet2` (
  `Rule_NO` varchar(255) DEFAULT NULL,
  `fun` varchar(255) DEFAULT NULL,
  `status` varchar(255) DEFAULT NULL,
  `valueFrom` varchar(255) DEFAULT NULL,
  `valueTo` varchar(255) DEFAULT NULL,
  `Level` varchar(255) DEFAULT NULL,
  `description` varchar(255) DEFAULT NULL,
  `H` varchar(255) DEFAULT NULL,
  `I` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of sheet2
-- ----------------------------
INSERT INTO `sheet2` VALUES ('900000001', 'Nature', 'Active', '', '', '校级', '校级', '', '');
INSERT INTO `sheet2` VALUES ('900000002', 'Nature', 'Active', '', '', '院级', '院级', '', '');
INSERT INTO `sheet2` VALUES ('900000003', 'StudentInterval', 'Active', '0', '100', '1-100', '1-100', '', '');
INSERT INTO `sheet2` VALUES ('900000004', 'StudentInterval', 'Active', '101', '300', '101-300', '101-300', '', '');
INSERT INTO `sheet2` VALUES ('900000005', 'StudentInterval', 'Active', '301', '500', '301-500', '301-500', '', '');
INSERT INTO `sheet2` VALUES ('900000006', 'StudentInterval', 'Active', '501', '1000', '501-1000', '501-1000', '', '');
INSERT INTO `sheet2` VALUES ('900000007', 'StudentInterval', 'Active', '1001', '1500', '1001-1500', '1001-1500', '', '');
INSERT INTO `sheet2` VALUES ('900000008', 'StudentInterval', 'Active', '1501', '2500', '1501-2500', '1501-2500', '', '');
INSERT INTO `sheet2` VALUES ('900000009', 'StudentInterval', 'Active', '2501', '3000', '2501-3000', '2501-3000', '', '');
INSERT INTO `sheet2` VALUES ('900000010', 'StudentInterval', 'Active', '3000', '3000000000', '3000以上', '3000以上', '', '');
INSERT INTO `sheet2` VALUES ('900000011', 'SponsorMoney', 'Active', '500', '2500', '500-2500', '500-2500', '', '');
INSERT INTO `sheet2` VALUES ('900000012', 'SponsorMoney', 'Active', '2501', '5000', '2501-5000', '2501-5000', '', '');
INSERT INTO `sheet2` VALUES ('900000013', 'SponsorMoney', 'Active', '5001', '7500', '5001-7500', '5001-7500', '', '');
INSERT INTO `sheet2` VALUES ('900000014', 'SponsorMoney', 'Active', '7501', '10000', '7501-10000', '7501-10000', '', '');
INSERT INTO `sheet2` VALUES ('900000015', 'SponsorMoney', 'Active', '10001', '15000', '10001-15000', '10001-15000', '', '');
INSERT INTO `sheet2` VALUES ('900000016', 'SponsorMoney', 'Active', '15001', '20000', '15001-20000', '15001-20000', '', '');
INSERT INTO `sheet2` VALUES ('900000017', 'SponsorMoney', 'Active', '20001', '25000', '20001-25000', '20001-25000', '', '');
INSERT INTO `sheet2` VALUES ('900000018', 'SponsorMoney', 'Active', '25001', '30000', '25001-30000', '25001-30000', '', '');
INSERT INTO `sheet2` VALUES ('900000019', 'SponsorMoney', 'Active', '30001', '50000', '30001-50000', '30001-50000', '', '');
INSERT INTO `sheet2` VALUES ('900000020', 'SponsorMoney', 'Active', '50001', '70000', '50001-70000', '50001-70000', '', '');
INSERT INTO `sheet2` VALUES ('900000021', 'SponsorMoney', 'Active', '70001', '100000', '70001-100000', '70001-100000', '', '');
INSERT INTO `sheet2` VALUES ('900000022', 'SponsorMoney', 'Active', '100001', '150000', '100001-150000', '100001-150000', '', '');
INSERT INTO `sheet2` VALUES ('900000023', 'SponsorMoney', 'Active', '150001', '200000', '150001-200000', '150001-200000', '', '');
INSERT INTO `sheet2` VALUES ('900000024', 'SponsorMoney', 'Active', '200000', '200000000', '200000以上', '200000以上', '', '');
INSERT INTO `sheet2` VALUES ('900000025', 'StudentLevel', 'Active', '', '', '官方代理社团', '官方代理社团', '', '');
INSERT INTO `sheet2` VALUES ('900000026', 'StudentLevel', 'Active', '500', '5000000', '金牌社团', '金牌社团', '', '');
INSERT INTO `sheet2` VALUES ('900000027', 'StudentLevel', 'Active', '400', '500', '银牌社团', '银牌社团', '', '');
INSERT INTO `sheet2` VALUES ('900000028', 'StudentLevel', 'Active', '300', '400', '铜牌社团', '铜牌社团', '', '');
INSERT INTO `sheet2` VALUES ('900000029', 'StudentLevel', 'Active', '200', '300', '普通社团V3', '普通社团V3', '', '');
INSERT INTO `sheet2` VALUES ('900000030', 'StudentLevel', 'Active', '100', '200', '普通社团V2', '普通社团V2', '', '');
INSERT INTO `sheet2` VALUES ('900000031', 'StudentLevel', 'Active', '0', '100', '普通社团V1', '普通社团V1', '', '');
INSERT INTO `sheet2` VALUES ('900000032', 'SponsorMoney', 'Active', '', '', '2000', '2000', '', '');
INSERT INTO `sheet2` VALUES ('900000033', 'SponsorMultiple', 'Active', '', '', '5', '5', '', '');
INSERT INTO `sheet2` VALUES ('900000034', 'CancelRemark', 'Active', '', '', '活动信息错误', '活动信息错误', '', '');
INSERT INTO `sheet2` VALUES ('900000035', 'CancelRemark', 'Active', '', '', '活动长时间没收到邀请', '活动长时间没收到邀请', '', '');
INSERT INTO `sheet2` VALUES ('900000036', 'CancelRemark', 'Active', '', '', '活动需要重新发布', '活动需要重新发布', '', '');
INSERT INTO `sheet2` VALUES ('900000037', 'CancelRemark', 'Active', '', '', '活动已达成目的', '活动已达成目的', '', '');
INSERT INTO `sheet2` VALUES ('900000038', 'CancelRemark', 'Active', '', '', '活动时间过期', '活动时间过期', '', '');
INSERT INTO `sheet2` VALUES ('900000039', 'CancelRemark', 'Active', '', '', '用户自主下架', '用户自主下架', '', '');
INSERT INTO `sheet2` VALUES ('900000040', 'ActivityType', 'Active', '', '', '招新类', '招新类', '', '');
INSERT INTO `sheet2` VALUES ('900000041', 'ActivityType', 'Active', '', '', '文艺类', '文艺类', '', '');
INSERT INTO `sheet2` VALUES ('900000042', 'ActivityType', 'Active', '', '', '表演类', '表演类', '', '');
INSERT INTO `sheet2` VALUES ('900000043', 'ActivityType', 'Active', '', '', '晚会类 ', '晚会类 ', '', '');
INSERT INTO `sheet2` VALUES ('900000044', 'ActivityType', 'Active', '', '', '体育类', '体育类', '', '');
INSERT INTO `sheet2` VALUES ('900000045', 'ActivityType', 'Active', '', '', '讲座类', '讲座类', '', '');
INSERT INTO `sheet2` VALUES ('900000046', 'ActivityType', 'Active', '', '', '比赛类', '比赛类', '', '');
INSERT INTO `sheet2` VALUES ('900000047', 'ActivityType', 'Active', '', '', '其它', '其它', '', '');
INSERT INTO `sheet2` VALUES ('900000048', 'AssosiationType', 'Active', '', '', '组织类-学生会', '组织类-学生会', '', '');
INSERT INTO `sheet2` VALUES ('900000049', 'AssosiationType', 'Active', '', '', '组织类-团委', '组织类-团委', '', '');
INSERT INTO `sheet2` VALUES ('900000050', 'AssosiationType', 'Active', '', '', '组织类-社团联合会', '组织类-社团联合会', '', '');
INSERT INTO `sheet2` VALUES ('900000051', 'AssosiationType', 'Active', '', '', '组织类-其他', '组织类-其他', '', '');
INSERT INTO `sheet2` VALUES ('900000052', 'AssosiationType', 'Active', '', '', '社团类-青年志愿者服务队', '社团类-青年志愿者服务队', '', '');
INSERT INTO `sheet2` VALUES ('900000053', 'AssosiationType', 'Active', '', '', '社团类-红十字会', '社团类-红十字会', '', '');
INSERT INTO `sheet2` VALUES ('900000054', 'AssosiationType', 'Active', '', '', '社团类-体育类社团', '社团类-体育类社团', '', '');
INSERT INTO `sheet2` VALUES ('900000055', 'AssosiationType', 'Active', '', '', '社团类-棋牌类社团', '社团类-棋牌类社团', '', '');
INSERT INTO `sheet2` VALUES ('900000056', 'AssosiationType', 'Active', '', '', '社团类-动漫社', '社团类-动漫社', '', '');
INSERT INTO `sheet2` VALUES ('900000057', 'AssosiationType', 'Active', '', '', '社团类-文娱类社团', '社团类-文娱类社团', '', '');
INSERT INTO `sheet2` VALUES ('900000058', 'AssosiationType', 'Active', '', '', '社团类-兴趣类社团', '社团类-兴趣类社团', '', '');
INSERT INTO `sheet2` VALUES ('900000059', 'AssosiationType', 'Active', '', '', '社团类-其他社团', '社团类-其他社团', '', '');
INSERT INTO `sheet2` VALUES ('900000060', 'CompanyMaterial', 'Active', '', '', '公司产品', '公司产品', '', '');
INSERT INTO `sheet2` VALUES ('900000061', 'CompanyMaterial', 'Active', '', '', '传单 ', '传单 ', '', '');
INSERT INTO `sheet2` VALUES ('900000062', 'CompanyMaterial', 'Active', '', '', '音箱', '音箱', '', '');
INSERT INTO `sheet2` VALUES ('900000063', 'CompanyMaterial', 'Active', '', '', '横幅', '横幅', '', '');
INSERT INTO `sheet2` VALUES ('900000064', 'CompanyMaterial', 'Active', '', '', '帐篷', '帐篷', '', '');
INSERT INTO `sheet2` VALUES ('900000065', 'CompanyMaterial', 'Active', '', '', '桌椅', '桌椅', '', '');
INSERT INTO `sheet2` VALUES ('900000066', 'CompanyMaterial', 'Active', '', '', '活动展架', '活动展架', '', '');
INSERT INTO `sheet2` VALUES ('900000067', 'CompanyMaterial', 'Active', '', '', '活动海报', '活动海报', '', '');
INSERT INTO `sheet2` VALUES ('900000068', 'CompanyMaterial', 'Active', '', '', '其他', '其他', '', '');
INSERT INTO `sheet2` VALUES ('900000069', 'AssociationMaterial', 'Active', '', '', '横幅', '横幅', '', '');
INSERT INTO `sheet2` VALUES ('900000070', 'AssociationMaterial', 'Active', '', '', '传单(黑白，彩色)', '传单(黑白，彩色)', '', '');
INSERT INTO `sheet2` VALUES ('900000071', 'AssociationMaterial', 'Active', '', '', 'KT板', 'KT板', '', '');
INSERT INTO `sheet2` VALUES ('900000072', 'AssociationMaterial', 'Active', '', '', '幕布', '幕布', '', '');
INSERT INTO `sheet2` VALUES ('900000073', 'AssociationMaterial', 'Active', '', '', '易拉宝', '易拉宝', '', '');
INSERT INTO `sheet2` VALUES ('900000074', 'AssociationMaterial', 'Active', '', '', '推头', '推头', '', '');
INSERT INTO `sheet2` VALUES ('900000075', 'AssociationMaterial', 'Active', '', '', '灯布', '灯布', '', '');
INSERT INTO `sheet2` VALUES ('900000076', 'AssociationMaterial', 'Active', '', '', '木构', '木构', '', '');
INSERT INTO `sheet2` VALUES ('900000077', 'AssociationMaterial', 'Active', '', '', '展位', '展位', '', '');
INSERT INTO `sheet2` VALUES ('900000078', 'AssociationMaterial', 'Active', '', '', '灯箱', '灯箱', '', '');
INSERT INTO `sheet2` VALUES ('900000079', 'AssociationMaterial', 'Active', '', '', '桁架', '桁架', '', '');
INSERT INTO `sheet2` VALUES ('900000080', 'AssociationMaterial', 'Active', '', '', '麦克风(耳麦，手麦，麦架)', '麦克风(耳麦，手麦，麦架)', '', '');
INSERT INTO `sheet2` VALUES ('900000081', 'AssociationMaterial', 'Active', '', '', '帐篷', '帐篷', '', '');
INSERT INTO `sheet2` VALUES ('900000082', 'AssociationMaterial', 'Active', '', '', '桌椅', '桌椅', '', '');
INSERT INTO `sheet2` VALUES ('900000083', 'AssociationMaterial', 'Active', '', '', '音箱', '音箱', '', '');
INSERT INTO `sheet2` VALUES ('900000084', 'AssociationMaterial', 'Active', '', '', '活动展架', '活动展架', '', '');
INSERT INTO `sheet2` VALUES ('900000085', 'AssociationMaterial', 'Active', '', '', '活动海报', '活动海报', '', '');
INSERT INTO `sheet2` VALUES ('900000086', 'AssociationMaterial', 'Active', '', '', '其他', '其他', '', '');
INSERT INTO `sheet2` VALUES ('900000087', 'CheckCompanyRejectedRemark', 'Active', '', '', '不存在您所输入的代理官口号令', '不存在您所输入的代理官口号令', '', '');
INSERT INTO `sheet2` VALUES ('900000088', 'CheckCompanyRejectedRemark', 'Active', '', '', '企业全称与营业执照上的不一致', '企业全称与营业执照上的不一致', '', '');
INSERT INTO `sheet2` VALUES ('900000089', 'CheckCompanyRejectedRemark', 'Active', '', '', '企业地址不详细', '企业地址不详细', '', '');
INSERT INTO `sheet2` VALUES ('900000090', 'CheckCompanyRejectedRemark', 'Active', '', '', '企业网址无法正常打开或网站内容不全', '企业网址无法正常打开或网站内容不全', '', '');
INSERT INTO `sheet2` VALUES ('900000091', 'CheckCompanyRejectedRemark', 'Active', '', '', '注册人姓名与身份证不一致', '注册人姓名与身份证不一致', '', '');
INSERT INTO `sheet2` VALUES ('900000092', 'CheckCompanyRejectedRemark', 'Active', '', '', '未上传正确的身份证', '未上传正确的身份证', '', '');
INSERT INTO `sheet2` VALUES ('900000093', 'CheckCompanyRejectedRemark', 'Active', '', '', '执照名称或注册号与营业执照不一致', '执照名称或注册号与营业执照不一致', '', '');
INSERT INTO `sheet2` VALUES ('900000094', 'CheckCompanyRejectedRemark', 'Active', '', '', '未上传正确的营业执照', '未上传正确的营业执照', '', '');
INSERT INTO `sheet2` VALUES ('900000095', 'CheckCompanyRejectedRemark', 'Active', '', '', '邮箱未验证', '邮箱未验证', '', '');
INSERT INTO `sheet2` VALUES ('900000096', 'CheckAssociationRejectedRemark', 'Active', '', '', '所属院系不正确或不存在', '所属院系不正确或不存在', '', '');
INSERT INTO `sheet2` VALUES ('900000097', 'CheckAssociationRejectedRemark', 'Active', '', '', '注册人姓名与身份证不一致', '注册人姓名与身份证不一致', '', '');
INSERT INTO `sheet2` VALUES ('900000098', 'CheckAssociationRejectedRemark', 'Active', '', '', '注册人学号与学生证不一致', '注册人学号与学生证不一致', '', '');
INSERT INTO `sheet2` VALUES ('900000099', 'CheckAssociationRejectedRemark', 'Active', '', '', '邮箱未验证', '邮箱未验证', '', '');
INSERT INTO `sheet2` VALUES ('900000100', 'CheckAssociationRejectedRemark', 'Active', '', '', '未上传正确的身份证', '未上传正确的身份证', '', '');
INSERT INTO `sheet2` VALUES ('900000101', 'CheckAssociationRejectedRemark', 'Active', '', '', '未上传正确的学生证', '未上传正确的学生证', '', '');
INSERT INTO `sheet2` VALUES ('900000102', 'AssociationSize', 'Active', '1', '10', '1-10人', '1-10人', '', '');
INSERT INTO `sheet2` VALUES ('900000103', 'AssociationSize', 'Active', '11', '30', '11-30人', '11-30人', '', '');
INSERT INTO `sheet2` VALUES ('900000104', 'AssociationSize', 'Active', '31', '60', '31-60人', '31-60人', '', '');
INSERT INTO `sheet2` VALUES ('900000105', 'AssociationSize', 'Active', '61', '90', '61-90人', '61-90人', '', '');
INSERT INTO `sheet2` VALUES ('900000106', 'AssociationSize', 'Active', '91', '120', '91-120人', '91-120人', '', '');
INSERT INTO `sheet2` VALUES ('900000107', 'AssociationSize', 'Active', '121', '150', '121-150人', '121-150人', '', '');
INSERT INTO `sheet2` VALUES ('900000108', 'AssociationSize', 'Active', '151', '200', '151-200人', '151-200人', '', '');
INSERT INTO `sheet2` VALUES ('900000109', 'AssociationSize', 'Active', '201', '250', '201-250人', '201-250人', '', '');
INSERT INTO `sheet2` VALUES ('900000110', 'AssociationSize', 'Active', '251', '300', '251-300人', '251-300人', '', '');
INSERT INTO `sheet2` VALUES ('900000111', 'AssociationSize', 'Active', '300', '1000000', '300以上', '300以上', '', '');
INSERT INTO `sheet2` VALUES ('900000112', 'AssociationSchoolType', 'Active', '', '', '组织类', '组织类', '', '');
INSERT INTO `sheet2` VALUES ('900000113', 'AssociationSchoolType', 'Active', '', '', '社团类', '社团类', '', '');
INSERT INTO `sheet2` VALUES ('900000114', 'AssociationRejectRemark', 'Active', '', '', '信息不匹配', '信息不匹配', '', '社团拒绝企业理由（联系情况界面）');
INSERT INTO `sheet2` VALUES ('900000115', 'AssociationRejectRemark', 'Active', '', '', '企业赞助金不适合', '企业赞助金不适合', '', '社团拒绝企业理由');
INSERT INTO `sheet2` VALUES ('900000116', 'AssociationRejectRemark', 'Active', '', '', '企业所在地不是所需所在地 ', '企业所在地不是所需所在地 ', '', '社团拒绝企业理由');
INSERT INTO `sheet2` VALUES ('900000117', 'AssociationRejectRemark', 'Active', '', '', '已受邀于其他企业赞助', '已受邀于其他企业赞助', '', '社团拒绝企业理由');
INSERT INTO `sheet2` VALUES ('900000118', 'AssociationRejectRemark', 'Active', '', '', '其他', '其他', '', '社团拒绝企业理由');
INSERT INTO `sheet2` VALUES ('900000119', 'CompanyRejectRemark', 'Active', '', '', '信息不匹配', '信息不匹配', '', '企业拒绝社团理由（联系情况界面）');
INSERT INTO `sheet2` VALUES ('900000120', 'CompanyRejectRemark', 'Active', '', '', '社团规模太小', '社团规模太小', '', '企业拒绝社团理由');
INSERT INTO `sheet2` VALUES ('900000121', 'CompanyRejectRemark', 'Active', '', '', '社团所在地不是所需所在地 ', '社团所在地不是所需所在地 ', '', '企业拒绝社团理由');
INSERT INTO `sheet2` VALUES ('900000122', 'CompanyRejectRemark', 'Active', '', '', '已受邀于其他社团活动', '已受邀于其他社团活动', '', '企业拒绝社团理由');
INSERT INTO `sheet2` VALUES ('900000123', 'CompanyRejectRemark', 'Active', '', '', '其他', '其他', '', '企业拒绝社团理由');
INSERT INTO `sheet2` VALUES ('900000124', 'AssociationProjectReject', 'Active', '', '', '信息不正确', '信息不正确', '', '社团活动书审核不通过原因');
INSERT INTO `sheet2` VALUES ('900000125', 'AssociationProjectReject', 'Active', '', '', '活动名称错误', '活动名称错误', '', '社团活动书审核不通过原因');
INSERT INTO `sheet2` VALUES ('900000126', 'AssociationProjectReject', 'Active', '', '', '活动所需金额超过限定范围', '活动所需金额超过限定范围', '', '社团活动书审核不通过原因');
INSERT INTO `sheet2` VALUES ('900000127', 'AssociationProjectReject', 'Active', '', '', '社团活动书所属社团已达到3个合作中的合同', '社团活动书所属社团已达到3个合作中的合同', '', '社团活动书审核不通过原因');
INSERT INTO `sheet2` VALUES ('900000128', 'CompanyProjectReject', 'Active', '', '', '信息不正确', '信息不正确', '', '企业赞助书审核不通过原因');
INSERT INTO `sheet2` VALUES ('900000129', 'CompanyProjectReject', 'Active', '', '', '活动名称错误', '活动名称错误', '', '企业赞助书审核不通过原因');
INSERT INTO `sheet2` VALUES ('900000130', 'CompanyProjectReject', 'Active', '', '', '赞助提供金额超出平台限定', '赞助提供金额超出平台限定', '', '企业赞助书审核不通过原因');
INSERT INTO `sheet2` VALUES ('900000131', 'CompanyProjectReject', 'Active', '', '', '赞助时间过长', '赞助时间过长', '', '企业赞助书审核不通过原因');
INSERT INTO `sheet2` VALUES ('900000132', 'AgentReward', 'Active', '0', '5000', '赞助金的8%', '赞助金的8%', '', '代理官获得奖励比例');
INSERT INTO `sheet2` VALUES ('900000133', 'AgentReward', 'Active', '5001', '10000', '赞助金的8.5%', '赞助金的8.5%', '', '代理官获得奖励比例');
INSERT INTO `sheet2` VALUES ('900000134', 'AgentReward', 'Active', '10001', '15000', '赞助金的9%', '赞助金的9%', '', '代理官获得奖励比例');
INSERT INTO `sheet2` VALUES ('900000135', 'AgentReward', 'Active', '15001', '20000', '赞助金的9.5%', '赞助金的9.5%', '', '代理官获得奖励比例');
INSERT INTO `sheet2` VALUES ('900000136', 'AgentReward', 'Active', '20001', '200000000', '赞助金的10%', '赞助金的10%', '', '代理官获得奖励比例');
INSERT INTO `sheet2` VALUES ('900000137', 'CompanyType', 'Active', '', '', '外资独资（欧美企业）', '外资独资（欧美企业）', '', '企业类型');
INSERT INTO `sheet2` VALUES ('900000138', 'CompanyType', 'Active', '', '', '外资独资（非欧美企业）', '外资独资（非欧美企业）', '', '企业类型');
INSERT INTO `sheet2` VALUES ('900000139', 'CompanyType', 'Active', '', '', '合资/合作（欧美企业）', '合资/合作（欧美企业）', '', '企业类型');
INSERT INTO `sheet2` VALUES ('900000140', 'CompanyType', 'Active', '', '', '合资/合作（非欧美企业）', '合资/合作（非欧美企业）', '', '企业类型');
INSERT INTO `sheet2` VALUES ('900000141', 'CompanyType', 'Active', '', '', '国营企业/上市企业', '国营企业/上市企业', '', '企业类型');
INSERT INTO `sheet2` VALUES ('900000142', 'CompanyType', 'Active', '', '', '民营/私营企业/非上市企业', '民营/私营企业/非上市企业', '', '企业类型');
INSERT INTO `sheet2` VALUES ('900000143', 'CompanyType', 'Active', '', '', '外企代表处', '外企代表处', '', '企业类型');
INSERT INTO `sheet2` VALUES ('900000144', 'CompanyType', 'Active', '', '', '其他', '其他', '', '企业类型');
INSERT INTO `sheet2` VALUES ('900000145', 'CompanySize', 'Active', '0', '50', '小于50人', '小于50人', '', '企业规模');
INSERT INTO `sheet2` VALUES ('900000146', 'CompanySize', 'Active', '50', '150', '50-150', '50-150', '', '企业规模');
INSERT INTO `sheet2` VALUES ('900000147', 'CompanySize', 'Active', '151', '500', '151-500', '151-500', '', '企业规模');
INSERT INTO `sheet2` VALUES ('900000148', 'CompanySize', 'Active', '501', '2000', '501-2000', '501-2000', '', '企业规模');
INSERT INTO `sheet2` VALUES ('900000149', 'CompanySize', 'Active', '2000', '', '2000以上', '2000以上', '', '企业规模');
INSERT INTO `sheet2` VALUES ('900000150', 'CompanyIndustry', 'Active', '', '', '家电', '家电', '', '企业行业');
INSERT INTO `sheet2` VALUES ('900000151', 'CompanyIndustry', 'Active', '', '', '通讯', '通讯', '', '企业行业');
INSERT INTO `sheet2` VALUES ('900000152', 'CompanyIndustry', 'Active', '', '', '房产建材', '房产建材', '', '企业行业');
INSERT INTO `sheet2` VALUES ('900000153', 'CompanyIndustry', 'Active', '', '', '医疗保健', '医疗保健', '', '企业行业');
INSERT INTO `sheet2` VALUES ('900000154', 'CompanyIndustry', 'Active', '', '', '工业制造', '工业制造', '', '企业行业');
INSERT INTO `sheet2` VALUES ('900000155', 'CompanyIndustry', 'Active', '', '', '现代服务', '现代服务', '', '企业行业');
INSERT INTO `sheet2` VALUES ('900000156', 'CompanyIndustry', 'Active', '', '', '日用消费品', '日用消费品', '', '企业行业');
INSERT INTO `sheet2` VALUES ('900000157', 'CompanyIndustry', 'Active', '', '', '酒店餐饮', '酒店餐饮', '', '企业行业');
INSERT INTO `sheet2` VALUES ('900000158', 'CompanyIndustry', 'Active', '', '', '食品饮料', '食品饮料', '', '企业行业');
INSERT INTO `sheet2` VALUES ('900000159', 'CompanyIndustry', 'Active', '', '', '化妆', '化妆', '', '企业行业');
INSERT INTO `sheet2` VALUES ('900000160', 'CompanyIndustry', 'Active', '', '', '汽车', '汽车', '', '企业行业');
INSERT INTO `sheet2` VALUES ('900000161', 'CompanyIndustry', 'Active', '', '', '服装', '服装', '', '企业行业');
INSERT INTO `sheet2` VALUES ('900000162', 'CompanyIndustry', 'Active', '', '', '奢饰品', '奢饰品', '', '企业行业');
INSERT INTO `sheet2` VALUES ('900000163', 'CompanyIndustry', 'Active', '', '', 'IT', 'IT', '', '企业行业');
INSERT INTO `sheet2` VALUES ('900000164', 'CompanyIndustry', 'Active', '', '', '珠宝饰品', '珠宝饰品', '', '企业行业');
INSERT INTO `sheet2` VALUES ('900000165', 'CompanyIndustry', 'Active', '', '', '广告企业', '广告企业', '', '企业行业');
INSERT INTO `sheet2` VALUES ('900000166', 'CompanyIndustry', 'Active', '', '', '烟酒类', '烟酒类', '', '企业行业');
INSERT INTO `sheet2` VALUES ('900000167', 'CompanyIndustry', 'Active', '', '', '金融', '金融', '', '企业行业');
INSERT INTO `sheet2` VALUES ('900000168', 'CompanyIndustry', 'Active', '', '', '旅游航空', '旅游航空', '', '企业行业');
INSERT INTO `sheet2` VALUES ('900000169', 'CompanyIndustry', 'Active', '', '', '其他', '其他', '', '企业行业');

-- ----------------------------
-- Table structure for student
-- ----------------------------
DROP TABLE IF EXISTS `student`;
CREATE TABLE `student` (
  `Student_NO` int(10) NOT NULL,
  `Student_LD_Number` varchar(16) DEFAULT NULL,
  `Student_Grade` varchar(10) DEFAULT NULL,
  `Ident_Type` varchar(20) DEFAULT NULL,
  `Ident_NO` varchar(20) DEFAULT NULL,
  `Bank_NO` varchar(30) DEFAULT NULL,
  `AliPay_NO` varchar(30) DEFAULT NULL,
  `Status` varchar(60) DEFAULT NULL,
  `Remark` varchar(255) DEFAULT NULL,
  `Update_Time` datetime DEFAULT NULL,
  `Education` varchar(50) DEFAULT NULL,
  `School_NO` int(15) DEFAULT NULL,
  `School_Name` varchar(200) DEFAULT NULL,
  `Major` varchar(100) DEFAULT NULL,
  `Entrance_Date` datetime DEFAULT NULL,
  `Name` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`Student_NO`),
  KEY `FKStudent321838` (`Student_NO`),
  CONSTRAINT `FKStudent321838` FOREIGN KEY (`Student_NO`) REFERENCES `user_info` (`User_No`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of student
-- ----------------------------
INSERT INTO `student` VALUES ('10000001', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null);

-- ----------------------------
-- Table structure for user_info
-- ----------------------------
DROP TABLE IF EXISTS `user_info`;
CREATE TABLE `user_info` (
  `User_No` int(10) NOT NULL AUTO_INCREMENT,
  `User_Name` varchar(60) DEFAULT NULL,
  `NickName` varchar(60) DEFAULT NULL,
  `Password` varchar(180) DEFAULT NULL,
  `Phone` varchar(18) DEFAULT NULL,
  `QQ` varchar(20) DEFAULT NULL,
  `WeChart` varchar(30) DEFAULT NULL,
  `Role` varchar(30) DEFAULT NULL,
  `User_Type` varchar(15) DEFAULT NULL,
  `Sex` varchar(8) DEFAULT NULL,
  `Email` varchar(100) DEFAULT NULL,
  `Create_Time` datetime DEFAULT NULL,
  PRIMARY KEY (`User_No`)
) ENGINE=InnoDB AUTO_INCREMENT=10000005 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of user_info
-- ----------------------------
INSERT INTO `user_info` VALUES ('10000000', '18825195397', '', '3c9909afec25354d551dae21590bb26e38d53f2173b8d3dc3eee4c047e7ab1c1eb8b85103e3be7ba613b31bb5c9c36214dc9f14a42fd7a2fdb84856bca5c44c2 ', '', '', '', 'Company', '', 'Female', '', '2016-08-20 20:20:57');
INSERT INTO `user_info` VALUES ('10000001', '18825195398', '', '4dbe3c0dbec4fe8d3009c3b826a6ce2e729d9ec615399c7af237c422beb57b5bcf8a94a65523b94674e3170144abc9ed7aaf8820186684c3befeab8589986387', '', '', '', 'Student', '', 'Female', '', '2016-08-20 20:20:57');
INSERT INTO `user_info` VALUES ('10000002', '18825195399', null, '3c9909afec25354d551dae21590bb26e38d53f2173b8d3dc3eee4c047e7ab1c1eb8b85103e3be7ba613b31bb5c9c36214dc9f14a42fd7a2fdb84856bca5c44c2 ', null, null, null, 'Student', null, 'Female', null, '2016-08-20 20:20:57');
INSERT INTO `user_info` VALUES ('10000003', '18825195310', null, '3c9909afec25354d551dae21590bb26e38d53f2173b8d3dc3eee4c047e7ab1c1eb8b85103e3be7ba613b31bb5c9c36214dc9f14a42fd7a2fdb84856bca5c44c2 ', null, null, null, 'Student', null, 'Female', null, '2016-08-20 20:20:57');
INSERT INTO `user_info` VALUES ('10000004', '18825195312', null, '3c9909afec25354d551dae21590bb26e38d53f2173b8d3dc3eee4c047e7ab1c1eb8b85103e3be7ba613b31bb5c9c36214dc9f14a42fd7a2fdb84856bca5c44c2 ', null, null, null, 'Student', null, 'Female', null, '2016-08-20 20:20:57');

-- ----------------------------
-- Table structure for user_validation
-- ----------------------------
DROP TABLE IF EXISTS `user_validation`;
CREATE TABLE `user_validation` (
  `Valid_ID` int(10) NOT NULL AUTO_INCREMENT,
  `User_ID` varchar(60) DEFAULT NULL,
  `Account_Type` varchar(10) DEFAULT NULL,
  `Account_Value` varchar(100) DEFAULT NULL,
  `Valid_Type` varchar(30) DEFAULT NULL,
  `Valid_No` varchar(300) DEFAULT NULL,
  `Valid_Status` varchar(20) DEFAULT NULL,
  `Created_Time` datetime DEFAULT NULL,
  `Updated_Time` datetime DEFAULT NULL,
  PRIMARY KEY (`Valid_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of user_validation
-- ----------------------------
SET FOREIGN_KEY_CHECKS=1;
